Results 1 to 1 of 1
2001-12-12, 09:20 #1
- Join Date
- Nov 2001
- Thanked 0 Times in 0 Posts
ListBox selected colour (Excel 97)
I am having a nightmare with listboxes. At present I am
1. Populating it
2. Selecting a value
3. changing the background colour as part of a validation process
Step 3 is the problem, when I do that the selected item appears to be reset. I say appears as the listIndex and value properties remain the same (i.e. they indicate the correct selected item). but the first item in the listbox is displayed with no selection and I can't work out how to make the selected item appear again. I've tried:
accountInfo_addresses_segKey.Selected(accountInfo_ addresses_segKey.ListIndex) = True
accountInfo_addresses_segKey.ListIndex = 16 'the listindex
And neither makes the display change! Yet if I don't change the background colour then all is well.
Please could anyone shed some light on this?