I am working on a Executive Dashboard that uses hyperlinks for navigation and comboboxs, list boxs, and option buttons to filter the view of the data they get. An issue I am having though, when they chnage a value in a combobox, for example, the focus stays on the combobox rendering hyperlinks un usable. They have to click somewhere else on the sheet, and then click on the hyperlink.
My attempt around this so far has been:
This works, however not perfectly. If they scroll down to a differnt chart and click an option button, it still tringers the combobox change event and jumps to cell B6. This causes the sheet to scroll back up, screwing up with there selection and with their view.
Is there a better way to do this!? Thanks in advance!