Userform

[Human2014]

Hello,

I have a quick question.
Is it possible to create a userform and link it to several cells ?

For example, I want to create a form with the following fields

Invoice Date
Invoice Number
Total Invoice amount

When I fill these fields I want them to appear in cell A10, B10 and C10 respectively

Thanks for the help

[Tnashnhsp1]

Sure you can add a command button then view code to add your code to your form so when you are ready you can submit them to cells.

It would be something like

Please Login or Register  to view this content.

[Human2014]

I created the userform with these fields

Invoice Date
Invoice Number
Invoice Amount
Date Submitted
Date Approved

Where should I put the code? in the module of I should create a button in the excel workbook and paste the code?

[Tnashnhsp1]

That code assumes you have added a command button in the Userform. If you haven't add one from the toolbox in the userform (click 'view' from the top menu if you can't see it) then add a command button, once you have added the command button, click 'view code' and enter the code in there so when you click the button in the form, the code will run.

Remember to change the "nameofinvoicedatetextbox.Value" to whatever you named the fields (presuming they are text boxes).

Let me know if you need further help.

[Human2014]

I am still having the same error

I put sheets("Single Invoice").Range("A10").Value = Invoice_date.Value

But it shows a debug message

[Human2014]

It gives me 0 as value in cell A10 B10 and D10

[Tnashnhsp1]

hmm i think it might be a lot quicker if you upload a copy of the spreadsheet to the thread (stripping out any personal data) rather than me trying to second guess the issue

[bakerman2]

Please Login or Register  to view this content.