Trouble collecting multiple input from Excel ribbon

I built an interface for the ribbon where two variables ( a dropdown and a string field) provide the inputs por a query. However, most ribbon actions are 1 to 1 (only a single input before starting the action).

Please Login or Register  to view this content.

How can I collect both inputs for my code?

Thanks....

Thanks for your help Andy. I understand your concern.

My plan was to deal with different scenarios inside the code "WU_CollectData". For example in case the recordset returned blanks, it would provide a "no results found with this criteria" message.

This application is meant for auditing purposes. It is only used when I find something unusual happening in the data I need to dig deeper into it. The data provided to me comes from multiple users and the file formats vary a lot. I am only interested in the details behind what they give me. This is the reason why I cannot attach a macro button to these files. I am seeking to build a 'floating' solution that I can use with any file.

To give you more details of some the things I tried:
1. The sub WU_CollectData called a second sub that placed the state input from the dropdown into a variable. WU_collectData handled the second from the edit box. Finally both inputs went into the query. This gave me an error were it would not allow me to call the subup with the dropdown.
2. I tried placing both input strings into the iribbon variable declaration. This would also give me an error and it would not run.

Is there another alternative using the ribbon??????

I do have the city names that are repeated in different states like you mentioned. However, that logic would be very complex. I would have to make sure that I select the right combination State-City before I run it.

Thanks for your help again.

Lovely!!!!! once again, you are the man! Just what I was looking for! Many many many thanks.