Hi,
I am sure this question has come up before but I can't seem to find it. I have a worksheet with activexcombo boxes overlaying cells. Some cells do not have an activex combobox overlaying it. I want to be able to tab through unlocked cells; the worksheet will be protected. I do not want to have to use the mouse key to activate each and every activex combobox and then go back to tabbing. It would be awesome if I can just tab through each cell, and if it has an activex combobox linked it will be activated so I can just type in the first couple letters and the matching word from its list is selected. I cannot do data validation because the drop down list is too small. I am new to comboboxes so using the codes is very confusing but if someone can help me out with that I would appreciate that. Thanks for your help.
Posted by: pamsw23@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar