Creating Multi Sheet User Form For Data Entry

[CristinaMariee]

I am currently in the process of self teaching myself how to create a multi-tab user form to help with data entry in a multi-sheet work book.

I have created the user form but am struggling with the code portion of things.

I have created the simple code for the cancel button to unload, and have customized ribbons to run the macro and open the user form. But cannot create the code for imputing data into the appropriate cells on the appropriate sheets.

If there is anyone out there willing to lend their brain to help me out, I would appreciate any help out there! I have spent hours watching youtube tutorials but still can't figure it out

Help Me!

 

[BrianJN1]

Firstly can you provide an image of your form?
It seems that some are unable to use materials mentioned here:http://https://www.mrexcel.com/forum/about-...tachments.html
and have sought to use their own Google My Drive account which actually requires User/Pwd to access.

Maybe dropbox is a good choice.

Then give the link as well as the destination(s) where data is to go.
One question, do you need to input a Product ID, a Client ID or some Identifier to so as to direct where the data is to go?
That may mean having one sheet being a LookUp table.

 

[gallen]

cannot create the code for imputing data into the appropriate cells on the appropriate sheets.

You give little information about the form and what information is being stored in the cells on the appropriate sheets.

Having said that it's very simple to write information to the sheets. For example if you had a textbox with information and you wanted to store it to sheet1 you could use:

Private Sub cmdSave_Click()
    
    'save the value of a textbox to cell A2 on sheet1
    Sheet1.Range("A2").Value = TextBox1.Text
    
    'Alternatively you can used named ranges:
    'This line saves the value of TextBox1 to a cell named '_UserName'
    [_UserName] = TextBox1.Text
    
End Sub

 

[My Aswer Is This]

My question would be:
What is a:
Your quote:
"create a multi-tab user form"

What do you mean by multi-tab

I know what MutiPage is but not multi-tab
Or do you mean Tab stript

We would need a lot more details about where in the Userform you want to enter the data and then where you want the data entered on your sheet.