userform memory
hey guys how do I get my userform textboxes to remember the value that was placed in it previously. For example if I type in "hello" in textBox1, the next time I open the same procedure and userform I want "hello" to be placed in textbox1. thanks for your time -- jnasr00 ------------------------------------------------------------------------ jnasr00's Profile: http://www.excelforum.com/member.php...o&userid=28515 View this thread: http://www.excelforum.com/showthread...hreadid=483804 |
userform memory
Hi Jnasr00,
Save the required values to a (possibly hidden) worksheet. Or save the values to defined names, again possibly hidden.Other possibilities might be to save the data to custom workbook properties or to the registry. --- Regards, Norman "jnasr00" wrote in message ... hey guys how do I get my userform textboxes to remember the value that was placed in it previously. For example if I type in "hello" in textBox1, the next time I open the same procedure and userform I want "hello" to be placed in textbox1. thanks for your time -- jnasr00 ------------------------------------------------------------------------ jnasr00's Profile: http://www.excelforum.com/member.php...o&userid=28515 View this thread: http://www.excelforum.com/showthread...hreadid=483804 |
userform memory
See a response to a very similar question from earlier in the week:
http://tinyurl.com/dte4d Hope this helps Rowan jnasr00 wrote: hey guys how do I get my userform textboxes to remember the value that was placed in it previously. For example if I type in "hello" in textBox1, the next time I open the same procedure and userform I want "hello" to be placed in textbox1. thanks for your time |
All times are GMT +1. The time now is 01:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com