View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tobi Tobi is offline
external usenet poster
 
Posts: 3
Default ComboBox_Change Event to Populate another Combox

I tried making a Model1_Enter event, and i get the error message:

"Compile error:
Expected user-defined type, not project"


I am not sure what to do, what I have is a function that connects to
the SQL Server via ADO, and the function takes in a SQL String as a
query, and then attempts to execute the query, and on error returns
false, so it trys and trys until the user gives a string that queries
cleanly, then returns the recordset.

Is there a comprehensive list of events in VB/VBA? I have the O'Reilly
VB/VBA in a nutshell book, and there is no list there, nor have I been
able to find one through search. I am stuck.