Yes, basically speaking a user form is a 'Window' or appliction interface.
Practically every Windows application, including Excel itself, runs on Forms
with code behind it.

Forms in Excel can be created in the VBA-editor. Use Alt+F11 to enter the
editor.

Once in the editor, by default you can add a user form using the second icon
in the toolbar of the editor. Once a form is added, doubleclick on it to
enter the "code view" where you can type VBA-code. Example:

Private Sub UserForm_Activate()
MsgBox ("Hello world")
End Sub

Do this and press [F5] to run the appropriate Sub.

Look for more info on "Excel VBA code" using Google. Have fun!!

"choice" schreef in bericht
...
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