Userform to add data to a specified range

scwisely

New Member
Joined
Jun 21, 2019
Messages
22
Hey All, Need help please - I have created a userform and need help with the VBA code to add the data to cells as described below:

textbox1 to cell AZ160 (and below)
textbox2 to cell BB160 (and below)

Also, I need a formula to auto-populate in BA160 (Formula = =$E$4&""&AZ160)

My sheet name is "Sheet13" ; however, that name changes based on cell reference to E4 -

I have the form completed just need the VBA code for the CommandButton1 to save the data into the row and subsequent rows

Thank You!
Scott
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
I never open user files.

I wish you would provide specific details but you are not doing that.

I like specifics like sheet names.

And you said:

easily add new items to a list

But you did not say where this list is.

And I surely do not know why you need a sheet name in Range("E4") to indicate the sheet name

If your sheet is named Alpha why do you need Alpha in Range("E4")

But maybe someone else will be able to help you.


A lot of folks on this forum are willing to open user files.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

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