UserForm_Initialize()
 

Is there a way to basically re-run the Sub UserForm_Initialize() so
when the form is re-displayed it will run it again?

There is code in the Sub UserForm_Initialize()that needs to be ran
each time the userform is displayed, it will determine if a button is
displayed or not, and if the form had been viewed (loaded) before in
the session, it will not check the location to see if the button
should be displayed or not.

The only other thing I can think of doing is maybe a function in a
separate module that will set that button on that userform when
called?

Please help.

Thanks

Joe

UserForm_Initialize()
 

Joe,

UserForm_Activate

Jim Cone
San Francisco, CA

"Joe Derr" wrote in message om...
Is there a way to basically re-run the Sub UserForm_Initialize() so
when the form is re-displayed it will run it again?

There is code in the Sub UserForm_Initialize()that needs to be ran
each time the userform is displayed, it will determine if a button is
displayed or not, and if the form had been viewed (loaded) before in
the session, it will not check the location to see if the button
should be displayed or not.

The only other thing I can think of doing is maybe a function in a
separate module that will set that button on that userform when
called?

Please help.

Thanks

Joe

UserForm_Initialize()
 

In case you don't understand the answer, Jim means move the code from the
Initialize event to the Activate event.

--

HTH

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


"Jim Cone" wrote in message
...
Joe,

UserForm_Activate

Jim Cone
San Francisco, CA

"Joe Derr" wrote in message
om...
Is there a way to basically re-run the Sub UserForm_Initialize() so
when the form is re-displayed it will run it again?

There is code in the Sub UserForm_Initialize()that needs to be ran
each time the userform is displayed, it will determine if a button is
displayed or not, and if the form had been viewed (loaded) before in
the session, it will not check the location to see if the button
should be displayed or not.

The only other thing I can think of doing is maybe a function in a
separate module that will set that button on that userform when
called?

Please help.

Thanks

Joe

UserForm_Initialize()
 

Thank you!

Private Sub UserForm_Activate()

End Sub

Works GREAT. I am using this else where in my code for other things I
wanted to do, and couldn't get them to work.

Thanks again!

Joe


"Jim Cone" wrote in message ...
Joe,

UserForm_Activate

Jim Cone
San Francisco, CA

"Joe Derr" wrote in message om...
Is there a way to basically re-run the Sub UserForm_Initialize() so
when the form is re-displayed it will run it again?

There is code in the Sub UserForm_Initialize()that needs to be ran
each time the userform is displayed, it will determine if a button is
displayed or not, and if the form had been viewed (loaded) before in
the session, it will not check the location to see if the button
should be displayed or not.

The only other thing I can think of doing is maybe a function in a
separate module that will set that button on that userform when
called?

Please help.

Thanks

Joe