+ Reply to Thread
Results 1 to 6 of 6

Move Out Of Combobox with the directional keys Please Help

  1. #1
    Registered User
    Join Date
    06-20-2014
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    19

    Exclamation Move Out Of Combobox with the directional keys Please Help

    Good day all im trying to find a vba code which will allow me to move in any direction using arrow keys from a selected combobox.
    All help is appreciated.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Move Out Of Combobox with the directional keys Please Help

    Hello porkchop101,

    Please tell us a bit more about your ComboBox, i.e.: Is it an ActiveX- control or Forms (Shape) ControlBox, and do you have it on a Specific Worksheet, or on a UserForm? Do you have any other code in your Workbook?

    Regards.
    Last edited by Winon; 03-05-2016 at 01:50 PM.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    06-20-2014
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    19

    Smile Re: Move Out Of Combobox with the directional keys Please Help

    Good Day thank you for your time I have attached the workbook in question. You will see that on Auto Quoting 1 you can not move from right to left as
    the combobox stops you. I know you can use the Tab to move right and enter to move Down but I would like to be able to move left as well without using the mouse.
    Best Regards
    Craig Pienaar

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Move Out Of Combobox with the directional keys Please Help

    Hi porkchop101,

    Thanks for the response.

    When you "Arrow" to a ComboBox, you have the option to select a designated value or not, and just hit "Esc" to exit, and your arrows are available to your liking.

    Probeer dit.

    Works for me.

    Kind regards.

  5. #5
    Registered User
    Join Date
    06-20-2014
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    19

    Thumbs up Re: Move Out Of Combobox with the directional keys Please Help

    Wow now i feel like a real derp ha ha wow feeling really silly.
    Than you so much for the help sorry im very new to comboboxes wow.
    Sorry for the time waste.
    Best Regards

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Move Out Of Combobox with the directional keys Please Help

    Hello porkchop101,

    You are welcome, no need to feel like a "a real derp", nor feeling really silly.

    Glad I could help, that is how we all learn.

    Thank you for adding to my Reputation, and marking your Thread as "Solved"

    Regards.

+ 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. Cannot Move Cursor with Arrow Keys
    By salooha in forum Excel General
    Replies: 5
    Last Post: 03-02-2016, 01:48 PM
  2. Shortcut Keys to Move Rows
    By billisnice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2015, 09:07 AM
  3. manual changing of keys in combobox list
    By Nitzan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 05:22 AM
  4. Is it possible to move legends with arrow keys?
    By Economystudent89 in forum Excel General
    Replies: 4
    Last Post: 10-08-2012, 09:13 AM
  5. [SOLVED] Arrow keys to move cell
    By Richard in forum Excel General
    Replies: 2
    Last Post: 05-01-2006, 05:25 AM
  6. [SOLVED] Using arrow keys to move between cells
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 11-27-2005, 11:15 PM
  7. Arrow keys won't move cursor
    By Walterius in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 06:05 PM

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