dynamic multipage
 

I have created a UserForm (UserForm12) which contains several frame
with TextBoxes that display summary financial information. There i
also a MultiPage (MultiPage1) in UserForm12 that the user can chang
certain assumptions that cause the summary financial information t
change.

What I am trying to do is have the TextBoxes containing the summar
financial statement information update anytime a textbox on any of th
MultiPage pages are changed.

Here is what I tried

Private Sub MultiPage1_Change
TextBox586.Value = Worksheets("IncStmtSummary").Range("F5")
TextBox586.Text = Format(TextBox586.Text, "$#,##0")
End Sub

The TextBox changes with this code but only when I tab to another pag
on the MultiPage. I want it to change whenever a TextBox is changed.

Thanks

--
Message posted from http://www.ExcelForum.com

dynamic multipage
 

You would need to use the change or click event for the textbox.

--
Regards,
Tom Ogilvy

"bforster1 " wrote in message
...
I have created a UserForm (UserForm12) which contains several frames
with TextBoxes that display summary financial information. There is
also a MultiPage (MultiPage1) in UserForm12 that the user can change
certain assumptions that cause the summary financial information to
change.

What I am trying to do is have the TextBoxes containing the summary
financial statement information update anytime a textbox on any of the
MultiPage pages are changed.

Here is what I tried

Private Sub MultiPage1_Change
TextBox586.Value = Worksheets("IncStmtSummary").Range("F5")
TextBox586.Text = Format(TextBox586.Text, "$#,##0")
End Sub

The TextBox changes with this code but only when I tab to another page
on the MultiPage. I want it to change whenever a TextBox is changed.

Thanks.


---
Message posted from http://www.ExcelForum.com/