B
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
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