Jason ,

It is Userform1.Show, but you need to put the code in a macro, in a standard
code module, and then call that macro.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JasonSelf " wrote in message
...
Ok, this time its almost embarrasing....I have finished my vba
application, thanks in no small part to the help I got here, and then
with the nasty weather this morning managed to forget my VBA book at
home.... The thing I cant remember is how to on click launch my
userform...I thought it was something like
UserForm1.Show but I guess I am wrong...any help would be
appreciated..

Sorry for asking stupid stuff,
Jason Self


---
Message posted from http://www.ExcelForum.com/