Excel - VBA - Multipage UserForms - Addressing Controls

[Conrad Clarke]

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

 

[Tom Urtis]

QUESTION: Do I need to add a reference to the specific page

No.

 

[Conrad Clarke]

Many thanks

 

[Conrad Clarke]

Many thanks