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!

Register Log in
  • Congratulations bkrike 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: *

  • Users: bstanton
  • Content: Threads
  • Order by date
  1. bstanton

    Number Formatting on a Userform Output

    I am using a user form to display calculations made using data from a spreadsheet. The code I have written produces the intended result, except I am having trouble figuring out how to format the output to the correct number of decimal places. For example, I would like the value for CalcGmb to...
  2. bstanton

    VBA Print Code for Generically Selecting a Printer

    I have the following code that I recorded with the Macro recorder in Excel to print a user selection to a USB printer. Application.ActivePrinter = "HP LaserJet P2035 UPD PCL 5 on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "HP LaserJet P2035 UPD PCL 5 on Ne01:"...
  3. bstanton

    Multiple Conditions with Conditional Formatting

    Is there a way to have more than 3 conditions for a cell when using conditional formatting? I tried to write code to add more, but I keep getting a run time on the fourth condition. If it's possible, any suggestions on how to make it work? Thank you in advance for any ideas.
  4. bstanton

    Selecting & Printing Ranges from Multiple Worksheets

    I would like to write code that selects certain ranges from different worksheets within the same workbook and then print that total selection to file or a printer depending on what the user decides. These ranges would be predetermined based on user input. For instance, if option one is...

Part and Inventory Search

Back
Top