Hello,
I am currently using the VBA in this thread:
https://www.excelforum.com/excel-for...combo-box.html
I have an ActiveX combo box that I need to be able to tab into and out of. The macro in the above thread allows me to tab into it but not out. Can anyone please help me figure out why it won't tab out of the combo box?
The macro I am using is:
Thank you in advance for any help you can provide!
Please Login or Register to view this content.
Mandy
Last edited by ValiMandy; 03-29-2017 at 02:53 PM.
Could you attach a copy of your worksheet?
Hello ValiMandy,
Welcome to the Forum.
WOW! You also remembered the Code Tags. Well done!
I don't believe you can Tab Out of a ComboBox.
But you could experiment with Activating another Cell on the Sheet, when you are done with any of the ComboBoxes.
Should you require further assistance with this then please attach a sample workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Regards.
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] .
Hello & Thank you very much!
I have attached a copy of the file. It is a crude copy but looks like that is what you were looking for anyway.
Basically I have a sheet with Item information and a sheet to enter production of those items. I want my production manager to be able to start typing the item # into the combo box and then select the correct item and tab to the next cell. There are many many items and so data validation is less than ideal because she will have to type the whole number or scroll through a really long list.
This could be a bad way to do this but was the best thing I could think of. I'll try to play with the code and activating different cells. That seems like a good plan! I'm fairly new at macros so we'll see. The most fun is figuring it out anyway!
Thanks again!
Have you considered building a userform for your data entry? Would probably solve your tabbing issue
I have considered it but have never used one before. I know (sort of) how to create one but that's about it. Maybe I will look into doing that. Thank you for the idea!!Originally Posted by unit285
Try this.. maybe it can help you get started. If I can be of any further assistance let me know I'm happy to help where I can.
You are an angel! This will work great! I'm going to play with userforms so I can learn how to use it but this will work great for my needs! Thank you again!!
Happy I could be of some help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks