Subscript out of range error - need suggestions

[kumar_excel]

Hi All,

I am beginner to VBA in excel and learning by making a small dummy project. However I am facing a issue and not getting a way to resolve it. Checked so many threads but no luck.

Issue - I have worksheet where I have 4 columns with 6 headers. I want to fill this 6 fields through user form. I have created a command btn in order to submit entries. Below is how my code looks like.

========================================================

Please Login or Register  to view this content.

----------------------------------------------

Please Login or Register  to view this content.

====================================================
Combo box list in Sheet2 while I want my entries(including combo box column) to be in Sheet1. I checked sheet name and all looks fine.

Seek all your suggestions.

[Tinbendr]

If you run the macro with sheet2 active, it's possible that the lastrow statement would return a incorrect value.

Declare your variables and use With to fully qualify the reference.

Please Login or Register  to view this content.