Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ActiveX Combo Box fires when Worksheet Activate Fires
I'm new to VBA and OOP, so this does not surprise me. I come from a FoxPro 2.6 background, so a lot of this doesn't make sense to me...and believe me, I'm trying here! I need the sort procedure to fire whenever a worksheet is changed (people here forget to do stuff like click the sort button...- kalecomm
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ActiveX Combo Box fires when Worksheet Activate Fires
OK. I've figured out that the Change Method of ComboBox1 isn't being reset to False, and that is why It's firing when the Activate Method of the Sheet fires. Anyone know why this would be? Best Regards, Kalecomm- kalecomm
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ActiveX Combo Box fires when Worksheet Activate Fires
This is all done in Excel 2000 I keep getting this error: "Unable to get the find property of the range class". I have one workbook with 3 sheets on it. I have 3 ActiveX ComboBoxes, one of which is dependent on the other. Sheet 1 is my "form" where the ActiveX ComboBoxes...- kalecomm
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
