View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default userform and variable

tom - yes, that's what i have to do. but if you have a macro where
you're calling various userforms from the main macro, it would be nice
to be able to differentiate them more easily, even tho i know the
initialize sub is directly connected to that specific userform......
when i've got five different userform windows open it gets a little
confusing LOL
susan

Tom Ogilvy wrote:
If you have

Private Sub frmGenerate_Initialize()

then that is the problem. No matter the userform name, it should always be

Private Sub Userform_Initialize()


--
Regards,
Tom Ogilvy


"Susan" wrote in message
ps.com...
gary - i'd be interested in the answer to this, too, because when i
change the name of a userform to something like frmGenerate, i can't
get the initialization to run..........
but i didn't think of declaring it as a variable in my global
declarations module.........
susan

Gary Keramidas wrote:
anyway to set a userform name to a variable i can use with <variable
name
instead of with userform1, with userform2, etc?

--


Gary