User Form not adding data

I made a user form to enter the data but I cannot get the data to copy to the worksheet.

The worksheet is named "WOODS" and the data should be entered in the first available blank row, starting with column "B".

Here is he code I tried but as of yet when I try to run the code nothing happens.

Please Login or Register  to view this content.

Any help would be wonderful.

Jim O

This is a stupid question but is the code actually running when you click the button?

Plenty of times I've renamed a button but not the sub and wondered why the code in it's click event wasn't working.

To check put a breakpoint on the first line of the sub, run the userfom and click the button.

Norie,

You are talking way over my head. I am a real novice when it comes to code. Could you explain that in other terms?

I created the form and added a Command Button (#1). I then copied the code from another file and I thought I made the proper corrections obviously I didn't.

What is a break point, how do I create one and how do I use it?

Thanks,

Jim O

Jim

All I was saying is that if you've renamed the command button then the code might not run.

What happens if you double click on the button when the form is in design view?

PS To set a breakpoint you select a line of code and press F9.

Jim

Can you attach the workbook?

Jim

To copy the userform.

1 Open the workbook the form is in and the workbook you want to copy it to.

2 Open the VBE with ALT+F11.

3 In the Project Explorer on the left locate the userform.

4 Drag the userform into the workbok you want to copy it to.

5 Close and save the workbook you copied the form to.

Jim

Still no userform.

Data is being added, but not directly under the existing data.

The reason for that is that you have filled the fomula down in column A which is the column you are using to find the next row.

What you could do is delete the formulas in the rows with no data, or change the column used to find the next row to column B.

It's probably best to delete the formulas and add to the code so the formula is copied down when new data is added.

Please Login or Register  to view this content.

Jim

Your code as it is doesn't fill in column F.

The first part of the formula checks if F is empty and returns "" if it is.

As soon as you fill in column F the formula will return a value

Shaft Data.xlsmTry this.

Basically what I did was just rewrite your formula in column A. The yellow line is where I changed your formula and then I dragged down.

I just changed it to look at the B cell instead of the F cell.

Hope this helps you out.

Thank you.