making a literal from expression

Hello,

I was just wondering if anone knew how to make a literal into an expression. In my code I have the name of the ComboBox that needs to change within a loop, however when I use that with the select case, the "UCase" makes it match "combobox#" instead of what it is representing.

The ComboBoxes are categories; then depending on what category from the combobox is selected the number entered beside it will be added to a variable (such as the first one is restaurants) which is keeping track of the totals.

Please let me know if anyone has any suggestions. Below I posted my code

Thanks!

Please Login or Register  to view this content.

Assuming that your combo boxes are on a user form, you can specify them with the controls property of the form.

e.g.

Please Login or Register  to view this content.

Does this help?

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Great! Would you please mark the thread as Solved?