Multipage Userform

[Legacy 436357]

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

 

[Legacy 436357]

 

[DanteAmor]

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:

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 = [COLOR=#0000ff]TextBox17[/COLOR].Value
End Sub