userform duplicating add data

[jsmity]

Guy's

Attached is a data entry form i've been working on as a project to help me learn VBA. I'm having a problem with it. I've got it to add the data from the userfrom (textboxes and comboboxes) to the next empty row on the worksheet. for some reason it's duplicating data that should be going into column a into column h. i thought it was because the cell in h has nothing in it but i've tried changing that by entering data. still nothing.

Can you have a look and see what my problem is.

thanks in advance

[Leith Ross]

Hello Jsmity,

I downloaded your workbook. Once I have input data to the form, should I press "ADD" in order to see the problem?

Sincerely,
Leith Ross

[mudraker]

In your CommandButton1_Click macro you have these 2 commands

Please Login or Register  to view this content.

[jsmity]

so if i remove then offset that should do it ?

Also how do i make all the data on the sspreadsheet default to uppercase ?

[jsmity]

I downloaded your workbook. Once I have input data to the form, should I press "ADD" in order to see the problem?

Sincerely,
Leith Ross

Yes if you press ADD then "close the input form" you will see on the worksheet that it has added the data from combox2 to A and H but i only want it in A

[mudraker]

If column H is to be blank then remove

Please Login or Register  to view this content.

else change the ComboBox2 to something else


to have it all uppercase you will need to add Ucase to each command

Please Login or Register  to view this content.

a easier way to write your codt to clear the form is

Please Login or Register  to view this content.

You could also replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.