Userform to add data to a specified range

[scwisely]

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

 

[scwisely]

Here's a link to my workbook , if you want to view/download -

https://app.box.com/s/2tcj2sagvpjfrba8tjuyurj1d7akmxxe

 

[My Aswer Is This]

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.​