![]() |
How do use VBA to avoid reverting to my default properties for a l
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! |
All times are GMT +1. The time now is 10:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com