Hello everyone,
does anybody know how to save a value as a Default of a text box in Excel form? So when you open the Excel form next time, it will remember the last entered value.
I use Show and Hide methods for Excel forms.
I did not find any Open method with Design mode to save the last entered value as a Defaullt.
Thank you.
surotkin
At the end of your combo change (which we will call "ComboBox1") routine, save the selection the user has made to a cell (eg A1).
In the initialisation routine for your form, type
Please Login or Register to view this content.and it will automatically place the contents of A1 into the combo box.Please Login or Register to view this content.
MS
Last edited by MartinShort; 04-22-2005 at 11:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks