Active X drop down list - always return to the item in the list that was selected.

I have an Active X drop-down list control in a sheet named "DashBoard". The List box has approx. 100 items in the list. If I am on item 25 in the list, when I return to DashBoard, I would like it to go back to item 25 but am not sure how to do this?

Please Login or Register  to view this content.

Thanks in advance.

Setting ListIndex to 1 resets the selection so remove that line.

Depending on your requirements, the default selection is -1 (nothing selected) so you may needed to add code to select the first item or you could set the Style property to DropdownList but that will prevent the user typing in the text portion of the control.

Thank you for your reply. I removed the ListIndex line but that did not help? There is no Style property available in Active X? When I work in the DashBoard, I might be on item 47 & I then click a button that takes me to another sheet to view detail. On that sheet, I have a "Return" button. I am trying to return to the item number (47) I was viewing in the DashBoard, if possible?
Thanks in advance

Perhaps the Style property is one of those not available on an ActiveX control placed on a worksheet... Can't check at the moment as using a phone but I'll check later if no one else comes in on this.

I have a ListBox - I did remove that line but it does not return to the correct line item? Is there a way , I can store the list index number when I leave the sheet and then return to that number?

The ListIndex will only change when another item is selected by the user (or code) or the list is reset/changed. Are you sure no other code is interacting with this?

Perhaps it would be an idea t upload a sample of your workbook that displays the issue.

I created a test workbook with same code & it worked perfectly. In the "live" workbook, I select item 27 and move to another sheet. If I manually click on the "DashBoard" sheet, item 27 is still selected. When I use code to move to DashBoard sheet, the item list changes - I have simplified the code but it still changes the list selection:

Please Login or Register  to view this content.

If I click manually on the sheet tab, it works?

Thanks for help & advice. I created a test file which worked as I expected? In the "live" file, it still does not revert to the correct item number but it is not a major issue so I will re-look when I have some time.