Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling (Function?) from Userform_Initialize to generate list of unique values for Combo box | Excel Programming | |||
Userform_Initialize event failing to be called | Excel Programming | |||
UserForm_Initialize | Excel Programming | |||
UserForm_Initialize? How to update. | Excel Programming |