MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I WANT INFO TO STAY IN TEXTBOX AFTER UPDATING USER FORM


Posted by RogerBlack on September 14, 2001 6:37 AM

Hi guys & GALS

Do any one know how i can keep data in a textbox after i have updated one record? Textbox1 is a master number and textbox2 will have a line number from 0-10. After i add the record on line 0 to the worksheet and go to add line 1 is there anyway i can have the user form return with the master number still there until i am ready to change it? I noticed someone asked a question close to this one down the road but it hasn't been answered. Maybe i'll get lucky for the 2 of us.

Cheers


Posted by Gregc on September 14, 2001 8:16 AM

You can always put the value in some far off cell and have the textbox reference that cell. Other than that I don't of a way to change a value in the textbox and have it stay.