Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic Input Forms
I'm a newbie to Excel programming and am having a problem with input
forms. I've written the following code for a form to come up when the worksheet opens and the user must input their name and serial number. I can't figure out nor find the answer in books as to how to save the info, name and serial, in a spreadsheet cell for later use. The following is as far as I've gotten and would appreciate any and all help. Thanks DLS Sub Auto_Open() Call Macro1 End Sub Sub Macro1() ' Macro1 Macro ' Macro recorded 7/30/2003 by DLS 'Sub Auto_Open() MsgBox "Hello" Call Macro2 'This calls for Macro2 to run End Sub Sub Macro2() ' ' Macro2 Macro ' Macro recorded 7/30/2003 by DLS 'Sub GetInput() Dim MyInput MyInput = InputBox("Enter your Name") + InputBox("Enter Serial Number") MsgBox ("Hello ") & MyInput A1 = MyInput End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic Input Forms
Sub Macro2()
' ' Macro2 Macro ' Macro recorded 7/30/2003 by DLS Dim MyInput as String MyInput = InputBox("Enter your Name") & " " & InputBox("Enter Serial Number") MsgBox ("Hello ") & MyInput Range("A1").Value = MyInput End Sub Regards, Tom Ogilvy DLS wrote in message om... I'm a newbie to Excel programming and am having a problem with input forms. I've written the following code for a form to come up when the worksheet opens and the user must input their name and serial number. I can't figure out nor find the answer in books as to how to save the info, name and serial, in a spreadsheet cell for later use. The following is as far as I've gotten and would appreciate any and all help. Thanks DLS Sub Auto_Open() Call Macro1 End Sub Sub Macro1() ' Macro1 Macro ' Macro recorded 7/30/2003 by DLS 'Sub Auto_Open() MsgBox "Hello" Call Macro2 'This calls for Macro2 to run End Sub Sub Macro2() ' ' Macro2 Macro ' Macro recorded 7/30/2003 by DLS 'Sub GetInput() Dim MyInput MyInput = InputBox("Enter your Name") + InputBox("Enter Serial Number") MsgBox ("Hello ") & MyInput A1 = MyInput End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Forms for Input | Excel Discussion (Misc queries) | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
xls input forms on the web | Excel Discussion (Misc queries) | |||
Visual Basic forms | Excel Discussion (Misc queries) | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions |