So I have a userform that has a multipage control for user to input date that will be sent to a worksheet once a command button is pressed. How do I code the command button to send the data to the worksheet? Normaly it would be an ******* event that say takes the data from textbox1.value and writes it in in Cell (1,1).value.
For a multipage, the way I envision it is something like:
If Multipage1.Value = 0
then
textbox1.value = Cell(1,1)value
else
If Multipage1.Value = 1
then
textbox2.value = Cell(1,1)value
else
....
and so on for each page. On my multipage, each page has multiple controls to input things on different areas depending on what tab is selected. It just seems like a ton of programming for this...am I wrong?
Here is a pic of my userform to help:
https://imgur.com/a/HQFYP8y
Here is a copy of my worksheet:
https://imgur.com/a/RErvIOo
For a multipage, the way I envision it is something like:
If Multipage1.Value = 0
then
textbox1.value = Cell(1,1)value
else
If Multipage1.Value = 1
then
textbox2.value = Cell(1,1)value
else
....
and so on for each page. On my multipage, each page has multiple controls to input things on different areas depending on what tab is selected. It just seems like a ton of programming for this...am I wrong?
Here is a pic of my userform to help:
https://imgur.com/a/HQFYP8y
Here is a copy of my worksheet:
https://imgur.com/a/RErvIOo
Last edited:
