button to launch my userform
 

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

Sorry for asking stupid stuff,
Jason Sel

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

button to launch my userform
 

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/

button to launch my userform
 

if the userform name is Userform1, then it is

Userform1.show

--
Regards,
Tom Ogilvy

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/