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: *

  1. alonzo51087

    VBA command functions

    Geoff, I am in no way asking you to write my 'project'. The only reason that I explained was to clarify my intentions. I don't just need the code for assigning a value to a cell, I need to understand how to assign a value from the user form. I've tried checking the help files and referencing...
  2. alonzo51087

    Export VBA forms

    Is there any way to export a vba form to an application file or have the UserForm run on its own instead of through Excel?
  3. alonzo51087

    VBA command functions

    I am creating a form based in VBA to run from Microsoft Excel. After the UserForm is completely filled out, the information that the user enters needs to be sent to various cells in the workbook. Is it possible for there to be a command button that closes the UserForm and leaves the...
  4. alonzo51087

    VBA command functions

    I'm trying add nformation to spreadsheets with a UserForm and create records in seperate Excel Workbook files.
  5. alonzo51087

    VBA command functions

    I tried using Private Sub CommandButton1_Click() Workbook.SaveAs Filename:="c:\code\*.xls" End Sub and it did not work. Is there any way to use the Save As command and have the user choose the filename?
  6. alonzo51087

    VBA command functions

    I used Private Sub CommandButton1_Click() Workbook.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodePage, TextVisualLayout) End Sub but I'm not sure how to attach an event to a command button. any ideas?
  7. alonzo51087

    VBA command functions

    Is there any way to make the Command Button to perform the "Save" (or "Save As") function in an Excel document and close the UserForm1 Macro? And what would the code be for a command button that clears all of the form's values?
  8. alonzo51087

    VBA command functions

    Is there any way to make the Command Button to perform the "Save" (or "Save As") function in an Excel document and close the UserForm1 Macro? And what would the code be for a command button that clears all of the form's values?
  9. alonzo51087

    Filling combo box with VBA

    Thank you John! I used your code, but I couldn't get it to work. Is there any way to add the Combo Box values inside of VBA (Forms>UserForm1) and input the chosen value from the form into the Excel Worksheet?
  10. alonzo51087

    Filling combo box with VBA

    i'm new to VBA also and I'm having a problem with adding information to a combo box. I tried using Private Sub Workbook_Open() With Sheet1.ComboBox1 .Clear .ListFillRange = "" .AddItem "A" .AddItem "B" .AddItem "C" End With End Sub , but it's not working. Could someone...

Part and Inventory Search

Back
Top