Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel's Dialog Box
Hi, good morning, I want to create a dialog box asking the name of the
person, (I know how to do this), my proble is when I try to use the name, I want to put the name in the cell: sheet 1 cell A1, but I can't, how I can do this? |
#2
|
|||
|
|||
Sheets("Sheet1").range("A1").value = Inputbox("Enter name")
Bob Umlas Excel MVP "filo666" wrote in message ... Hi, good morning, I want to create a dialog box asking the name of the person, (I know how to do this), my proble is when I try to use the name, I want to put the name in the cell: sheet 1 cell A1, but I can't, how I can do this? |
#3
|
|||
|
|||
filo
Sub test() Worksheets("Sheet1").Range("A1").Value = InputBox("enter a name") MsgBox "Your Name is " & Range("A1").Value End Sub Gord Dibben Excel MVP On Mon, 14 Feb 2005 09:53:03 -0800, "filo666" wrote: Hi, good morning, I want to create a dialog box asking the name of the person, (I know how to do this), my proble is when I try to use the name, I want to put the name in the cell: sheet 1 cell A1, but I can't, how I can do this? |
#4
|
|||
|
|||
And if you want to design your own userform, you may want to visit Debra
Dalgleish's site for some tips: http://www.contextures.com/xlUserForm01.html filo666 wrote: Hi, good morning, I want to create a dialog box asking the name of the person, (I know how to do this), my proble is when I try to use the name, I want to put the name in the cell: sheet 1 cell A1, but I can't, how I can do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel's Dialog Box | Excel Discussion (Misc queries) | |||
Excel's annoying "Getting Started" dialog box. | Excel Discussion (Misc queries) | |||
Save a Copy/Overwrite changes dialog box | Excel Discussion (Misc queries) | |||
Update dialog box | Excel Worksheet Functions | |||
Update / don't update dialog box | Excel Worksheet Functions |