PDA

View Full Version : Solved: How do I create a "dialog box"...?



Lester
11-07-2007, 04:27 AM
Hello
I want to create a 'dialog box' (if that's the right terminology for it)...basically a window/user interface with several fields, which the user fills in. Once they click the 'Enter' button, this data will then be entered into a spreadsheet as a new row.
Is dialog box the thing it is called? I tried typing this into the excel-help wizard thing but it didn't come up with what I wanted.

Can anyone point me in the right direction?

Many thanks,
Regards
Lester.

rory
11-07-2007, 04:31 AM
A userform is what you are after.

Lester
11-07-2007, 04:34 AM
A userform is what you are after.
That's the ticket. Thanks, rory.

Bob Phillips
11-07-2007, 06:04 AM
Here is some starter info http://www.contextures.com/xlUserForm01.html

Lester
11-08-2007, 12:21 PM
Here is some starter info http://www.contextures.com/xlUserForm01.html (http://www.contextures.com/xlUserForm01.html)
That's really useful. Thanks.