dynamic multipage

[bforster1]

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

 

[Tom Ogilvy]

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