Search results for query: *

I use Excel 2010 and the forms Checkboxes. When I print the sheet the checks in the checkboxes are difficult to see. They are too light and tiny. Is there a way to make the checks in checkboxes darker or larger? Thanks.

I have an Excel 2010 sheet with a lot of checkboxes on each row. The user has to type some info in the left side and then move across the row to check some of the checkboxes. The problem is that it's easy to get up or down a row and therefore check the checkbox on the wrong row. I would like...

I have a form in Excel 2010 that my coworkers and I have to print doing our job. I use the following code to print the form: Sheets("ControlSheet").PrintOut When I print the form, it prints fine but when some of my co-workers print it, it doesn't fit on one page. It actually takes 4 pages to...

I have a form in Excel 2010 that has borders around many of the cells. I used the fine dotted line because the solid line prints out too dark. This was fine for 2 weeks but yesterday, when I printed the form, parts of the borders are missing. There doesn't seem to be any reasoning to it, just...

I have a worksheet with 7 columns (C to I). I paste a large table from the internet into these columns and some of them are duplicates. I would like to be able to run a macro to find the duplicate cells (in Column C) and move the duplicate rows (including the original row) from Columns C to I...

I need to create many mutually exclusive option buttons and it's very difficult and time consuming doing it by hand! I have 20 rows where I need a group of 3 in columns J4:L4, then a group of 2 in columns M4:N4, then another group of 3 in columns O4:Q4 and finally a group of 2 in columns U4:V4...

I have working code to create 3 groups of checkboxes as shown below. I would like to be able to create mutually exclusive groups as the checkboxes are being created. Private Sub CreateCheckboxes_Click() ' deletes all checkboxes and then creates new ones centered in the column and row...

I have a Word macro that I got working with a lot of help from a few forum members for which I am very thankful. Now, due to some changes at work, I have to switch to using Excel 2010 rather than Word. Could someone change the following Word code to work in Excel 201? In the Word document the...

I have a folder with about 100 files in it. Each file consists of a single Word 2003 table with 9 columns. I need to copy column 3 of each file in the folder and paste it into another file called "Test" that has 2 columns. I want to put column 3 in the first column of "Test" and I want to put...

I have a macro that works to format a formfield in a label but I want to use it over and over for more than just one label. The macro puts a space between 6 characters in a postal code when the user presses tab to leave the field. It is called from the Exit event in the formfield in Word 2003...

Sorry, I just posted this in the Access VBA category by mistake! It should be here I think since it's about VBA for Word 2003. I want to correct the capitalizion for Surnames such as McDonald, O'Leary, etc. I've found the following function on this forum FAQ section but I can't figure out how...

I've found the following function on this forum but I can't figure out how to make it work. I'm not very good with VBA but am slowly learning it. Where do I put the line: txtSurname=Propercase(txtSurname,0) And also where do I put the main function that comes after that line? I'm using Word...