Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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. "ben" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design/Logic Comments
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. "Tom Ogilvy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Logic please | Excel Discussion (Misc queries) | |||
Design | New Users to Excel | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |