Using ComboBox to call another function

[JezLisle]

How is it possible to take the choice from the Combo Box and send that into a Stored Procedure statement in Excel VBA

I have 3 Combo Boxes, Months, Years, Date.

I'm trying to fillout these into this statement to run my Stored Procedure...

Please Login or Register  to view this content.

This is my full code that brings back the results

Please Login or Register  to view this content.

How is it possible to do this?

[Andy Pope]

Something like this, change the combo names to suit.
Also assume the Values are in the correct format for simple substitution.

Please Login or Register  to view this content.

[JezLisle]

Thanks for that, I've tried it and I get a Compile Error: Variable not Defined, what do I need to delcare the ComboBox as?

[Andy Pope]

So what does your code look like?

[JezLisle]

My code

Please Login or Register  to view this content.

[Andy Pope]

I assume you have the combo boxes on a userform and the code is within that userforms code module, yes?

[JezLisle]

No my Combo's are just on the worksheet, with a Range of Data to populate them linked to them...

[Andy Pope]

Is the code in the worksheet object or a standard code module?

If in a standard code module you will need to create a reference to the controls on the sheet.

[JezLisle]

I used the ListFillRange in the Combo Properties

How do you mean create reference controls?

[Andy Pope]

You said the compiler was complaining about the references to the comboboxes.

Currently the compiler does not know where or what cboMonths is.

You need to create a reference to it.

Please Login or Register  to view this content.

Changing Sheet1 to appropriate name.

[JezLisle]

Excellent that works... Thanks :-)