Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. calvinb

    Highlight row the cursor is in?

    Thank you, Combo! That works fine. Much appreciated!!
  2. calvinb

    Highlight row the cursor is in?

    Thanks Combo. That works exactly like I wanted. I have one co-worker who doesn't like it so I was wondering if there is a way to turn it on and off... say with a checkbox or button. I tried today with an existing checkbox on the page but couldn't get it to work. Thanks Skip. I'll check that out!
  3. calvinb

    Resize page automatically for printer

    Yeah, I think it's the printer drivers also but my computer is fine. It prints on one page but a couple of my co-workers seem to have different drivers and it doesn't work for them. I'm not allowed to change the drivers so they have just moved the right border on the sheet until it all fits and...
  4. calvinb

    How to make printed checkmarks darker

    I have it on flat now but it's not very noticeable!! Just a tiny checkmark in the middle of a square box. Thanks for the suggestion though.
  5. calvinb

    How to make printed checkmarks darker

    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.
  6. calvinb

    Highlight row the cursor is in?

    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...
  7. calvinb

    Resize page automatically for printer

    Ok. I tried that code at work but it still didn't print everything on one page. It still printed about a half inch of the right column on a second page and the bottom row on another page. The two computers that are causing this problem seem to be different than other computers at work. That...
  8. calvinb

    Resize page automatically for printer

    Thanks for you quick answer!! I'll give it a try tomorrow at work. I appreciate the help.
  9. calvinb

    Resize page automatically for printer

    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...
  10. calvinb

    Part of my cell borders in Excel 2010 don't print anymore!

    Larena: Thanks for the suggestions but I have tried on different printers here and at work but there is no difference. The odd thing is that it used to work on all the printers and I haven't changed the borders but it just stopped printing parts of them. ColinMitton: Thank you also for your...
  11. calvinb

    Part of my cell borders in Excel 2010 don't print anymore!

    Forms. I'm using a heavier line now. The borders are all there but it looks terrible because they are so dark!! And around the checkboxes part of the borders are missing so the checkboxes definitely have something to do with this problem.
  12. calvinb

    Part of my cell borders in Excel 2010 don't print anymore!

    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...
  13. calvinb

    move duplicate cells to top of list

    I'm crossposting this to MrExcel forum.
  14. calvinb

    move duplicate cells to top of list

    I'm not getting anywhere with this!! I did the record macro thing and here is the results: Sub Macro4() ' ' Macro4 Macro ' Sheets("Import").Select Range("C4:I13").Select Selection.Copy Sheets("Data").Select Range("C4").Select ActiveSheet.Paste...
  15. calvinb

    move duplicate cells to top of list

    I want to do it with coding. Thanks for your suggestion though.
  16. calvinb

    move duplicate cells to top of list

    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...
  17. calvinb

    Create multiple Option Button Groups

    Ok, I did it manually!! It took all afternoon but I entered the option buttons in individual groupboxes for each row and each group and it is all working fine. Thanks for your efforts, Skip! PS I still want to be able to find duplicate entrys and move them to the beginning of the list using...
  18. calvinb

    Create multiple Option Button Groups

    Thanks Skip! I removed the other lines and just left 3 for demonstration purposes. The way this works is that we have a table of information online that I copy and paste on the sheet called "Import". (I would like to then check that for duplicates and have them move to the top rows as...
  19. calvinb

    Create multiple Option Button Groups

    Thanks Skip. Here is the code I get when I create an option button and a group: Sub Macro1() ' ' Macro1 This is the default sizes when I added an option button and a group. ' ' ActiveSheet.OptionButtons.Add(370.5, 32.25, 72, 72).Select ActiveSheet.GroupBoxes.Add(478.5, 34.5, 72...
  20. calvinb

    Create multiple Option Button Groups

    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...

Part and Inventory Search

Back
Top