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 Chriss Miller 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: episode80
  • Content: Threads
  • Order by date
  1. episode80

    Too long code

    Hi, I have a long code behind a command button. Now, when I try to run it I'll get an error tag which says that code is too long. How can i solve this problem? It isvery essential that all that code is behind this command button. Thanks! -episode80
  2. episode80

    Print settings

    How can the printing option from the toolbar (file->print) or via the quicklaunch button be disabled? I have one optionbutton in the worksheet (with specified printig area) for printing purposes and I want the button to be the only way to do the printing. Thanks!
  3. episode80

    Print area settings

    Hi, I have an excel document which has two sheets. Now, I want to set it so that when the user wants to take a print the result would always be specified area from the sheet2. How that can be done? Thanks!
  4. episode80

    Commas and dots!

    I have this program (uses forms) which works just fine, but I also want make sure that the progrma works when the user uses commas, dots or both as decimals in the program while he/she inputs number. Is it possible to make excel understand this? At the moment if I input for example 1,3 and 1.3...
  5. episode80

    Saveas and Load codes

    I want to create save&load functions behind commandbuttons. What would be the saveas code that prompts the SaveAs window and saves the current excel document. And it would be good if save format would automatically be xls format and the suggested filename "Project". And how would the load code...
  6. episode80

    How to export data from forms to worksheets?

    I think this is quite easy question but I'm a beginner so help me please... So, I just want to export data from forms (for example from textboxes) to normal worksheet cells. What is the code to do that in VB? Thank you! :)

Part and Inventory Search

Back
Top