+ Reply to Thread
Results 1 to 5 of 5

Need to be able to Tab into a combo box using the code I already have

  1. #1
    Registered User
    Join Date
    11-04-2015
    Location
    Des Moines, IA
    MS-Off Ver
    2013
    Posts
    3

    Need to be able to Tab into a combo box using the code I already have

    I found a great way to automatically fill in a value by starting to type it, but to get into the combo box I have to double click the cell with a drop down list, what I would like to do is to Tab into the cell(combo Box) as well as double click, I already have a way to tab out of the combo box, and that works great, I just don't know how to get into the combo box, I am including a copy of the file. "Que", "Type", and "Completion Status" all have a drop down list, I need to be able to tab into "Que" then "Type" then "Completion Status", enter the beginning of the value I want, which should autofill, then tab to the next one, any help would be appreciated, thanks

    the code I have used comes from: http://www.contextures.com/xlDataVal11.html
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Need to be able to Tab into a combo box using the code I already have

    I'm not exactly sure what you're asking but this will auto-enter the combobox when you select one of the DV dropdowns.

    Please Login or Register  to view this content.
    You could comment out the entire Worksheet_BeforeDoubleClick event procedure.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    11-04-2015
    Location
    Des Moines, IA
    MS-Off Ver
    2013
    Posts
    3

    Re: Need to be able to Tab into a combo box using the code I already have

    what I'm looking for is thus:

    in a normal spreadsheet, you can Tab from cell to cell, and even if you have a combo box on top of a cell it will only tab into the cell and not the combo box

    with the code I have found online and am using, the option to double click a cell: have a drop down list appear, start entering a value, and it auto-completes, is present. Then I can tab out of that combo box and it tabs to the next cell, which I then have to double click that cell to then repeat the process

    what I want to be able to do is have the Tab do the same thing, without having to double click, but keeping the double click option as well

    thanks

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Need to be able to Tab into a combo box using the code I already have

    Well then I did understand what you wanted.

  5. #5
    Registered User
    Join Date
    11-04-2015
    Location
    Des Moines, IA
    MS-Off Ver
    2013
    Posts
    3

    Re: Need to be able to Tab into a combo box using the code I already have

    yes, I replaced the code I had with the one you gave, and It did work, thank you

+ 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. Code works with Combo Box-Form Control, but not with Combo box - ActiveX Control
    By nangys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2014, 08:51 AM
  2. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  3. [SOLVED] combo box code help
    By laduk in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2013, 09:01 AM
  4. combo box user form code for two combo boxes
    By robert.begley1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-01-2012, 02:25 PM
  5. Combo Box Code
    By penfold in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-16-2008, 03:50 PM
  6. [SOLVED] Combo Box code
    By Gordon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2006, 07:35 PM
  7. [SOLVED] Combo Box Code
    By jd815 in forum Excel General
    Replies: 1
    Last Post: 09-14-2005, 04:05 PM

Tags for this Thread

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