No, it's a built-in dialog. UserForms are used to create custom dialogs. You
have to write your own code to provide functionality to the UserForm.

Perhaps you should first look at Dave McRitchie's site to learn a bit about
macros and VBA (although UserForms are not specifically addressed).

http://www.mvps.org/dmcritchie/excel/getstarted.htm

But basically, you add a UserForm to your VBA project, add controls to it so
that the user can interact with it, and write code to handle the user's
input.

--

Vasant






"choice" wrote in message
...
When you click on tools then options, is that a userform?
how do you go about creating user forms? is there a menu option, or is it
all in VBA? if its in VBA, could somebody please give me a simple code so
that i can play around with it.

Thanks in advance