dynamic multipage

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top