Multipage Userform

L

Legacy 436357

Guest
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 a moderator:

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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 = [COLOR=#0000ff]TextBox17[/COLOR].Value
End Sub


8235a799476a3c2d32644cf19c46f5f6.jpg


d226de516343ed5b90d6a1db1217c775.jpg
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top