Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc Angus Comber[_2_] Excel Programming 1 November 7th 03 01:18 PM


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"