View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default userform and variable

then you seem to be asking the same question as Gary, so the answer is the
same

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Susan" wrote in message
ups.com...
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