Compiler Error: Variable not defined (Error Associated with Combobox)

[asgharhussaini]

Hi Guys,

I am using combobox change procedure to fill another combobox according to values selected in combo1.
but receiving an error message "Compile Error: Variable Not Defined". Kindly check the code and suggest the solution.

Best Regards,
Hussaini

Please Login or Register  to view this content.

[Kyle123]

Are you sure that it's not elsewhere in the sheet?

[asgharhussaini]

Please see below the complete code in procedure.

Please Login or Register  to view this content.

[Kyle123]

Are you sure that you have all the controls on the worksheet? Isn't there anything highlighted in blue when you get that message?

[asgharhussaini]

Nothing gets highlighted with blue only first line gets yellow as shown in image. Capture1.JPG

[Kyle123]

Ok, time you uploaded a workbook

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[asgharhussaini]

Kyle! Kindly help me getting out this problem. Thanks.

[Kyle123]

Did you read my last post? - we are helping you. Why are you asking again? You're being a bit rude.

[asgharhussaini]

File attached please check. and sorry Kyle nothing like that. I am thankful to you.
I have deleted some data which is being called by filters on report sheet to bring the attachment into acceptable size.

Thanks.

[Kyle123]

Your workbook works fine for me, I suggest you close and re-open. Also, have a look here:http://dailydoseofexcel.com/archives...ivex-controls/

[asgharhussaini]

Kindly close an re-open the file again to receive again. may 2 to 3 times you will see the error.

I tried but didn't find any "*.exd" file in C drive

[Kyle123]

I do not get the error. Have you checked the name of the comboboxes and cleared out the .exd files?

[asgharhussaini]

I tried but didn't find any "*.exd" file in C drive. I didn't see any problem in combobox names.

[Kyle123]

Then I'm afraid I can't help you

[asgharhussaini]

The problem is not solved Guys! please help help help

[Norie]

I can't replicate the problem you describe in your first post, though I do get a 'subscript out of range' error here.

Please Login or Register  to view this content.

That's because there is no worksheet named 'Home' in the uploaded workbook which makes me wonder if the workbook you've uploaded is actually the one you are having the problem with.

[asgharhussaini]

It had a confidential stuff so I deleted it but it doesn't have any contribution in subject problem.
Kindly try to suggest the solution I will be thankful to you.