• 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?



    Reply To: ListBox selected colour (Excel 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: