Search results for query: *

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

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?

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

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

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?

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?

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?

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?

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?

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