Good morning experts,
I want to be able to change the background color of a combobox based off its selected value compared to the current calendar quarter. something like:
If combobox.value = "1st Quarter" AND current quarter is not 1 then
combobox.backcolor = vbRed
combobox.value = "2nd Quarter" AND current quarter is not 2 then
combobox.backcolor............ and so on.
Please let me know if you need further information.