Compiler Error: Variable not defined (Error Associated with Combobox)
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.
Are you sure that it's not elsewhere in the sheet?
Last edited by Kyle123; 04-23-2015 at 05:15 AM.
Please see below the complete code in procedure.
Please Login or Register to view this content.
Are you sure that you have all the controls on the worksheet? Isn't there anything highlighted in blue when you get that message?
Nothing gets highlighted with blue only first line gets yellow as shown in image. Capture1.JPG
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
Kyle! Kindly help me getting out this problem. Thanks.
Last edited by asgharhussaini; 04-23-2015 at 05:48 AM.
Did you read my last post? - we are helping you. Why are you asking again? You're being a bit rude.
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.
Last edited by asgharhussaini; 04-23-2015 at 05:47 AM.
Your workbook works fine for me, I suggest you close and re-open. Also, have a look here:http://dailydoseofexcel.com/archives...ivex-controls/
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
I do not get the error. Have you checked the name of the comboboxes and cleared out the .exd files?
I tried but didn't find any "*.exd" file in C drive. I didn't see any problem in combobox names.
Then I'm afraid I can't help you
The problem is not solved Guys! please help help help
I can't replicate the problem you describe in your first post, though I do get a 'subscript out of range' error here.
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.Please Login or Register to view this content.
If posting code please use code tags, see here.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks