Design/Logic Comments

[Guest]

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.

 

[Guest]

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

 

[Guest]

Thanks for your reply Ben.
The other state could be done the next day or what ever time. They don't
have to be one after the other. So i am looking something like...saving the
first state and doing the second at some other time.

 

[Tom Ogilvy]

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.

 

[Guest]

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]

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.

 

[Guest]

Thanks Ben and Tom for your suggestions. I am sure the suggestions would be
helpful. Also Tom, thanks for your advice about describing the problem.