VB Code to Capture Data from User Form

[rizmomin]

Hello:

Please refer to the attached sheet.

I am learning how to create a User Form in Excel.
I have created a form and need to capture data when data is entered but when i run, it gives error.
Also need a command Button in Sheet1 to activate the user form.

Please help me figure out why it is giving error.

Thanks

Riz

[Norie]

Add a new module Insert>Module.

Paste this code in it.

Please Login or Register  to view this content.

Right click the button, select Assign Macro..., pick OpenForm from the list an press Enter.

The form will now open when you click the button.

[rizmomin]

Hi Norie:

That solves one problem.
Can you now please click the button to see the error in my code and rectify the error problem.

Thanks

Riz

[Norie]

x1Up should be xlUp.

[rizmomin]

Hi Norie:

I got it ...Thanks a lot.

I also need to use the Close Button to close the form and also after entering the data, need to clear the field in the form for the next entry.


Thanks

Riz