Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You must be unloading your form, which removes it from memory. Try hiding it
instead with Me.Hide -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "V-Man" wrote in message ... I have created a userform where employees can choose one of two options. If one option is selected, then several text boxes disappear, if the other option is selected, the text boxes reappear. I am using an IF/Then code with the textbox1.visible = true. My challenge is when I go from one userform and then back to the original. The textbox1.visible reverts back to the default setting of true. How do I program it so that these settings are permanent - based on the feedback of my user? If they select it to be invisible, it stays invisible, and vica versa. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting the default properties for cells in all new spreadsheets | Excel Discussion (Misc queries) | |||
Reverting to default chart fill colors (in Powerpoint?) | Charts and Charting in Excel | |||
How can I stop data labels reverting to a default position | Charts and Charting in Excel | |||
How do I avoid fields being automatically filled in by default? | New Users to Excel | |||
Where does Excel get the default properties without startup file? | Excel Discussion (Misc queries) |