Excel userform save 1

[autex]

Ok I have an excel "template" with some good macros built in. The user interfaces with the "template" through a user form. The form has textboxes that the user fills out and that excel uses for sorts etc. After user enters in textboxes and clicks the submit button excel runs macros and color coded labels show up on the form telling user what they typed in. If the user saves this userform, closes and reopens it again later with a toolbar button I want the color coded information to show up on the form not the empty text boxes. How do I get the user form to change with each user save?

 

[HughLerwill]

autex,

I suspect you may have to refresh the values on the userform with the values (previously set by it) on your sheet(s) when you fire up the WorkBook. The WorkBook_Open event or the Form_Initialize event may be a good places to insert the required code.

regards Hugh,

 

[HughLerwill]

Checkout the ControlSource property for the Controls on the UserForm too.

 

[autex]

I think I see what you are saying. You are saying pull from the spreadsheet the values that were written to it by the userform. ?????
Unfortunately, the values aren't written anywhere on the spreadsheet the values entered onto the form by the user are used to select rows before a certain date and delete them.
where would you hold these values?

 

[HughLerwill]

autex,

To recall the values I think you'll have to store them somewhere like in Sheet(2).Visible = False

regards Hugh

 

[HughLerwill]

Sheet I meant Sheets...

 

[autex]

allright thanks. I'll give that a shot.