Multipage Userform
Results 1 to 3 of 3

Thread: Multipage Userform
Thanks Thanks: 0 Likes Likes: 0

  1. #1

    Join Date
    Oct 2018
    Posts
    323
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Multipage Userform

    Hi,

    I have a table that stores data. It has too many fields to fit on a userform. My question can a multipage form allocate the data to the same row in the table?

    Thank you
    Last edited by inactiveuserps17; Aug 20th, 2019 at 04:43 PM.

  2. #2

    Join Date
    Oct 2018
    Posts
    323
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multipage Userform


  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,773
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Multipage Userform

    Quote Originally Posted by xjohnson View Post
    My question can a multipage form allocate the data to the same row in the table?
    The answer is yes

    Each textbox or control is unique, no matter what page the control is in, you simply refer to the textbox.

    ie.

    Texbox1 is on page1.
    Textbox17 is on page2.


    When you pass the data to the sheet you use this:

    Code:
    Private Sub CommandButton1_Click()
      Dim lr As Long
      lr = Range("A" & Rows.Count).End(xlUp).Row + 1
      Range("A" & lr).Value = TextBox1.Value
      Range("M" & lr).Value = TextBox17.Value
    End Sub



    Last edited by DanteAmor; Aug 23rd, 2019 at 03:11 PM.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •