+ Reply to Thread
Results 1 to 12 of 12

On ActiveX ComboBox Change, switch focus to the active worksheet

  1. #1
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    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!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    What should happen when they select a value in the combobox?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    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

  4. #4
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    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!

  5. #5
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

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

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    Don't use LinkedCell.

  7. #7
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

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

  8. #8
    Registered User
    Join Date
    06-26-2015
    Location
    US
    MS-Off Ver
    2010
    Posts
    2

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    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?

  9. #9
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    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!

  10. #10
    Registered User
    Join Date
    06-26-2015
    Location
    US
    MS-Off Ver
    2010
    Posts
    2

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    • 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

  11. #11
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    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

  12. #12
    Forum Contributor
    Join Date
    07-07-2014
    Location
    ericbartha.com
    MS-Off Ver
    2016 Professional
    Posts
    126

    Re: On ActiveX ComboBox Change, switch focus to the active worksheet

    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change a combobox (activex control) based on another cell?
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2013, 11:32 AM
  2. [SOLVED] WorkSheet ActiveX Combobox entry problem
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 06:58 PM
  3. ActiveX ComboBox Firing on change in Cells
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2013, 07:43 AM
  4. Code to change LinkedCell of ActiveX ComboBox
    By ozhunter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2011, 07:10 AM
  5. Copy and Paste to Worksheet using Combobox (ActiveX)
    By okriskao in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-23-2009, 09:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1