OK...without going into all of the details of exactly what I'm doing:
I have a combobox on an Excel worksheet that lists the months January, February, March, etc. The combobox references a range of cells (let's say B1 through B12) to be able to display the values to choose from.
I want to be able to do this without a macro.
If the month selected from the combobox is the current month or a future month, I want to display an error.
So, for example, right now we're in November. If the user selects November, I want to display a message like "Invalid month" or something. It's not the displaying of a message I'm having trouble with. It's how to get the program to determine that November is equal to the current month or that December (if that month was selected) is greater than November, etc.
In other words, if I was using numeric values for the months (January being "1", February being "2", etc), it would be easy to determine greater than, equal to, less than etc. But since I'm using text for the months, I don't know how to make the comparison.