PDA

View Full Version : Solved: Compile Error - Variable Not Defined



Acer76e
07-13-2009, 07:22 AM
Hi guys --

So I posted this log that tracks calls recently, and after a few more enhancements, I can't seem to get the functionality to work now where if I drop down a ComboBox it sorts and pulls the lists into the second box.

I've uploaded the file here >> it's on 4shared.com and the path is -- /file/117786919/ad9b1c8c/HW_OFS_Log_V771.html

User ID - admin
Password - admin

Go into "New Input" >> Drop down the Topic box and choose one, and you'll get the error...it's supposed to populate the SubTopic, but doesn't.

Thanks a bunch!

Bob Phillips
07-13-2009, 07:55 AM
Your password is wrong

Bob Phillips
07-13-2009, 08:01 AM
You have Option Explicit in the code, and you are not declaring your variables. Declare them.

Acer76e
07-13-2009, 08:52 AM
Sorry -- you're right -- wrong file I uploaded...

The password is hewittofs for the admin User ID.

Acer76e
07-13-2009, 08:59 AM
Can I take that out of the code and still not affect the rest of the spreadsheet? Or do I really need to declare all variables?

Bob Phillips
07-13-2009, 10:31 AM
You could remove the line Option Explicit, but I would advise declaring all of the variables myself.

Acer76e
07-13-2009, 11:15 AM
Ok -- awesome, thank you much!