Wouldn't be much point in entering the values if they weren't stored anyway.
Most userforms as described would be feeding some form of data base or Table
in excel. So seems like you could just pickup the values from the last
entry made by the user or last entry if only one user.

--
Regards,
Tom Ogilvy


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