if it is a userform, simply Hide it and do not unload it, this will keep
the values exactly as they last appeard, and then on the userform.activate
event delete the values you don't want there
userform name = ok

ok.hide


"Ajit" wrote:

I have one template for each state. Each state has couple of forms to select
the values from (listboxes and option button selections). After user makes
all the selections, output is dumped into excel sheet as required.

What I want to achieve :
After doing one state, when user starts second state, I want to give the
ability to user to prefill the form controls with the values from the
previous completed state (with the ability to change the prefilled values).

I am working on the design yet and would appreciate expert views on the
design/logic from the forum.

--
Ajit