what i do in that case, is to dump those desired values, into the spreadsheet
somewhere, prefferably hidden then in the userform activate event to reload
them

sub userform_activate
box1.value = range("a1").value
box2.value = range("a2").value
end sub
etc...
this will load the values whenever the userform is shown


"Tom Ogilvy" wrote:

Just some advice. Using the word form is pretty ambiguous. You could be
talking about a paper form that has been recreated on an Excel worksheet and
controls added over the cells to allow choices or you could be talking about
a userform. Another example; people say forms controls. This seems clear
as there is a forms toolbar and one would think that is what they mean, but
the controls from the control toolbox toolbar are defined in the MSforms
type library, so that can be ambiguous as well.

The clearer you describe what you are doing the more likely you are going to
get a response that addresses the issue.

--
Regards,
Tom Ogilvy

"Ajit" wrote in message
...
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