On ActiveX ComboBox Change, switch focus to the active worksheet

Hi everyone,

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:

Please Login or Register  to view this content.

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!

When the end users selects a value, that value is set to the "LinkedCell" and is then used as a reference to SUMIFS/IFS/COUNTIF formulas to provide the correct view of the data they are looking for. This all works fine. The issue is mostly with the blue navigation bar at the top. Those are all shapes with hyperlinks.

I attached a snapshot of ONE of the sheets to help provide a visual.

Snapshot.JPG

Could anyone anyone offer some input?

I just want the focus to go to the active worksheet after the user makes a selection with a combobox/button ect, without having to target a specific range ie Range("B6")

Thanks!

I can't believe no one has any input! I can't seem to get this to work...

Why would that make a difference? The Focus would still be on the combobox after they make a selection, no?

I'm having this same issue with any activeX control I embed in the sheet - and its seems to be rather difficult to find any useful info.

Right now I have inserted a webbrowser and an adobe acrobat reader control to a sheet and when I click them, I lose focus on excel. I can select cells but I can not window and delete them, or type in them. Once I double click and force control back to excel - I then lose focus on the activex control and excel works.

Then problem is I want to control the switching via VBA and .select and .activate methods on both cells and my embeded controls don't do squat!

Any advice?

Hey JJohnson74, and welcome to Excel Forum. Please be aware your post is in violation of the forum's rule # 2.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.

Please review these rules and then start your own thread, thanks!

• 1. This post has been dead 2 months, the reason I posted was to A. Ressurect your already dead post, and B. To shine light on a question many people seem to have and no one is answering on ActiveX / Sheet focus issues.
• 2. My issue is the same as yours (Managing focus on your sheet and activeX components) You want a way to control the focus on the sheet between the two - this is exactly what I am looking for. Hence, if your question gets answered, so does mine.
• 3. I am stating that my issue matches yours, the only question I can see is me asking "Any advice?" which is not really a needed statement. If you like, I can simply edit and delete that line.

In truth starting my own topic, would have netted me the same result, putting a post at the top of the list. I was simply trying to help a member out by bringing this back to the top of the list since we had the same issues. Apparently you didn't see it the same way. Sorry to intrude

I would do something like this.

Please Login or Register  to view this content.

this way you select a cell in the workbook but ist not Messing up your Scrolling

Greets
Loki

JJohnson74,

I do not disagree with you, I was just informing you, a new member, of the forums rules. I know that the admins are usually big on that one.

Thanks LordLoki, this is exactly how I solved it back in April. Hopefully this works for you too, JJohnson!