Duplicate Declaration in the Current Scope error

[bala04msw]

Dear Forum experts,

Kindly guide me for the following error:

I have developed a user form for data entry purpose. i have tried for two things.

1. In the combo box (cbsitename), i have done a filter with text option. like , if i type "S" the name start with "S" will come automatically.
2. In the combo box (cbsitename), if i select any value, automatically, dependent values will appear for the next text box.

Errors:

1. As per the given code - Compile error: "Duplicate Declaration in the current scope" is coming

2. If i remove the underlined code : Dim ws As Worksheet" Runtime Error 9: Subscript out of range is coming.

Kindly guide me, how to fix the issue.

Regards

Please Login or Register  to view this content.

[shg]

In this,

Please Login or Register  to view this content.

VBA requires straight quotes.

[bala04msw]

Dear shg,

Thanks for your reply. Since i am new to vba, i am learning through online only. I unable to understand your inputs. Could you please modify the code and teach me. Then i can relate my mistakes here.

Regards

[shg]

Do you see the difference in these two lines?

Please Login or Register  to view this content.

[bala04msw]

Yes, "" is the difference

[shg]

Right. VBA requires the second.