Results 1 to 4 of 4

Excel - VBA - Multipage UserForms - Addressing Controls

This is a discussion on Excel - VBA - Multipage UserForms - Addressing Controls within the Excel Questions forums, part of the Question Forums category; Hi I have a Multipage UserForm Named "Snr_Debt_Input". It has 5 Pages. Each Page has a Frame ( F_TLARepay; F_TLBRepay; ...

  1. #1
    New Member
    Join Date
    Jun 2007
    Posts
    3

    Default Excel - VBA - Multipage UserForms - Addressing Controls

    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

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    10,982

    Default Re: Excel - VBA - Multipage UserForms - Addressing Controls

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

  3. #3
    New Member
    Join Date
    Jun 2007
    Posts
    3

    Default

    Many thanks

  4. #4
    New Member
    Join Date
    Jun 2007
    Posts
    3

    Default

    Many thanks

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com