Ssaving data from userform to multiple worksheets.

Hi,

I am a beginner in advance excel and I have created a simple application using excel-VBA. I am using a single user form to enter the data and to be saved in the respected worksheet. I tried If conditions but it's getting too long code. Then I studied the sample codes which I found here but unfortunately it didn't work. I'm just briefing here what I'm doing and what I want, as below,

userform1 contains : combo box1 - contains a list of customers.
Combo box2 - contains a list of products.
Combo box3 - packing sizes.
Textboxes - contains Date, quantity, bill no, amount

There are 18 different sheets with the name of customers. Using above mentioned form I am choosing a particular customer, fill the other information and need to save it to the sheet named to that particular customer.

Can anybody guide me regarding how to write the code for it in VBA?

Thanks in advance.

K Mahendra.

Thank you so much Andy. It helped a lot.

K Mahendra

Thanks again for your help Andy.

One more problem.

I have two text boxes on user form, where I input the amount. It's getting saved on excel sheet. I want those amounts to be entered in 000000.00 format on excel sheet. I have put the sum and subtraction formula on excel sheet. When I enter the amounts, I should get those formulae work, currently it's not working.

Please guide me.

Thanks,
K Mahendra