combining dialog boxes

[roth_nj]

hi,

i did a quick search and didnt find anything that helped.

in my macro program, i have 10 inputboxes pop up and get an entry from the user. can i combine those to it comes up as one dialog box with 10 input fields?

thanks

nick

[roth_nj]

here is the code in my program

Please Login or Register  to view this content.

[royUK]

Create a userform with textboxes to replace the inpuboxes.

[roth_nj]

i have no idea what a userform is

[royUK]

A userform is bascally a dialog that you can program. In the VB Editor from the Insert menu you can add a UserForm to the project. To this you can add textboxes for user input and a commandbutton to use that input.

There's an example called Database form here

http://www.excel-it.com/vba_examples.htm