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.
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.
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] .
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
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.
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks