Pete,

You need to create a macro to call the form (Userform1.Show). The macro can
be invoked several ways, a worksheet button, a toolbar button, or a menu.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pete Woodhead" wrote in message
om...
I have am self taught and I have been using Excel for about two years
now. I'm working my way into macros and control buttons (trying to
create forms). I set up a simple contact form using a tutorial that
it turns out was incomplete (it only contained lessons 1-3 out of 5).
It did not explain how I could open this form inside a worksheet. Can
someone please offer me some help. I created the form in Excel using
the Tools/Macro/VBE followed by Insert/Userform. It contains several
labels, text fields and two command buttons"
Any advice on how open this as a useable form and on where I can find
some relevant tutorials would also be appreciated.
Thanks,
Pete