Conrad Clarke
New Member
- Joined
- Jun 22, 2007
- Messages
- 3
Hi
I have a Multipage UserForm Named "Snr_Debt_Input". It has 5 Pages. Each Page has a Frame ( F_TLARepay; F_TLBRepay; F_TLCRepay etc)
Within each Frame are 10 x TextBoxes and 10 x Labels)
I am trying to construct a routine which retrieves the value of each TextBox from a spreadsheet (which is open):
I have the following:
Dim cntrl As Control
For each cntrl in Snr_Debt_Input.F_TLARepay
If TypeName (cntrl) = "TextBox" Then _
cntrl = Format(Sheets ("Inputs").Range ("C134").value,"###.00")
Next cntrl
QUESTION: Do I need to add a reference to the specific page e.g.
For each cntrl in Snr_Deb_Input.Page1.F_TLARepay
Thanks foryour elp
I have a Multipage UserForm Named "Snr_Debt_Input". It has 5 Pages. Each Page has a Frame ( F_TLARepay; F_TLBRepay; F_TLCRepay etc)
Within each Frame are 10 x TextBoxes and 10 x Labels)
I am trying to construct a routine which retrieves the value of each TextBox from a spreadsheet (which is open):
I have the following:
Dim cntrl As Control
For each cntrl in Snr_Debt_Input.F_TLARepay
If TypeName (cntrl) = "TextBox" Then _
cntrl = Format(Sheets ("Inputs").Range ("C134").value,"###.00")
Next cntrl
QUESTION: Do I need to add a reference to the specific page e.g.
For each cntrl in Snr_Deb_Input.Page1.F_TLARepay
Thanks foryour elp