Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems resetting backcolor in listbox
I have a userform to allow the user to select the period to view. He
can either select a month or a quarter to view. I have two listboxes, one for the months - lstMonths and one for the quarters - lstQuarters. What I'd like to have happen is that when he clicks into one listbox, the other box grays out. I'm trying to do it like this: Private Sub lstMonth_Click() lstMonth.BackColor = &H80000005 'White lstQuarter.ListIndex = -1 lstQuarter.BackColor = &H8000000F 'Grey End Sub Private Sub lstQuarter_Click() lstQuarter.BackColor = &H80000005 'White lstMonth.ListIndex = -1 lstMonth.BackColor = &H8000000F 'Grey End Sub When the userform comes up the first time, both boxes have a white background. When I click on one of them, the other one does go gray. But when I click on the other one, both of them are grey and they stay that way. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet backcolor within range | Excel Discussion (Misc queries) | |||
Excell FileOPenDialog from another App, and listbox multiselect problems | Excel Programming | |||
Changing backcolor of commandbutton | Excel Programming | |||
Pivot DataRange BackColor | Excel Programming | |||
BackColor property code | Excel Programming |