I have a Userform with multi-tabs. If I enter a value into a textbox on tab 1, switch to tab 2 and then go back to tab 1 the textbox is clear.
How can I can get the textboxes to hold their data when switching back and forth?
I have a Userform with multi-tabs. If I enter a value into a textbox on tab 1, switch to tab 2 and then go back to tab 1 the textbox is clear.
How can I can get the textboxes to hold their data when switching back and forth?
Hi guitarsweety
I've just tested this and it's not happening to me, please could you upload your file
No problem, the Userform is Firstplant
Where exactly is the data not being saved when you switch tabs?
If I select Yes on Level 1, go to Level 2 and then back to Level 1. The textbox is clear. It's not holding the Yes value.
In the Tabstrip_change event you have:
which resets the value.Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Rory has it, remember you have this code 5 times.
Any suggestions on how to fix this?
If you want the Yes/No to show on the sheet "ProcessHazardMgmt", use this:
And maybe in the UserForm_Initialize, which will show in the textbox what was selected before:Please Login or Register to view this content.
Please Login or Register to view this content.
I'm tried that but now i'm getting an Object required error
get a list of multiple tabs in a worksheet
I have a wkst with 40 tabs; how do I get a list of them?
@DanielaLascu,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks