Results 1 to 2 of 2
Thread: More UserForm Stuff (XL2002)
2003-02-13, 05:47 #1
- Join Date
- Mar 2001
- Dallas, Texas, USA
- Thanked 1 Time in 1 Post
More UserForm Stuff (XL2002)
<P ID="edit" class=small>(Edited by Tricky on 13-Feb-03 01:47. You may have to save the example sheet to your PC to use it. I was unable to open it through my browser but it works fine from my PC...)</P>Example Attached
A three part question if I may...
1) I have a multipage UserForm where the user fills in many textboxes. On the last page of the UserForm (Index12), I want to summarize the users entries. One place to take a final look before Saving the form and writing the data. One such textbox is GMName. While the user is typing his name into that textbox, I would need for a label on the summary page to update itself. The label name is LabGM.
2)Same thing as #1 but with a twist...There are three textboxes named: CityName, StateName & ZipName. On the summary page, I would need those three items combined to form one label, LabLocation. The fornat would be CityName, StateName ZipName.
3)Thinking ahead, I beleive I would have to start with:<pre>Private Sub GMName_Change()
Then Sub Summarize()would have the instrux for updating the labels...
What if the userform were reopened to make a few changes (an address change)? The Change events would trigger the labels to update but the textboxes that were not changed might appear empty on the summary page...How can I make sure that the summary page retains the values from the appropriate text boxes?- Ricky
2003-02-13, 06:15 #2
- Join Date
- Feb 2001
- Weert, Limburg, Netherlands
- Thanked 0 Times in 0 Posts
Re: More UserForm Stuff (XL2002)
I haven't used a multi page form yet, but the multipage control has a change event:
Private Sub MultiPage1_Change()
MsgBox "changed page"
'Get the selected page
I would use this event to trigger code to update the controls on the summary page.