Rabu, 06 Agustus 2014

Re: [ExcelVBA] Activating an Activex Combobox when linked cell is selected

 



Although you can ask a combo box what cell it's linked with, I don't think you can ask a cell which combo box(es) is linked to it.
 
You could run some initialisation code that buzzes through all the combo boxes and stores a list of cells that have combo boxes.  Then you could use "selection change" code to look up this list and activate the associated combo box if applicable.
 
Don't know how you'd handle the possibility that two combo boxes could be linked to the same cell.  Probably ignore it and hope it doesn't happen by accident.
 
> I want to be able to tab through unlocked cells;
> the worksheet will be protected.
 
I haven't looked at it, but I suspect that tabbing will only tab through the unlocked cells.  This would mean that your combo boxes would need to be in unlocked cells too.

Regards, Dave S
 
----- Original Message -----
Sent: Sunday, July 27, 2014 6:01 AM
Subject: [ExcelVBA] Activating an Activex Combobox when linked cell is selected

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. 

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1432 / Virus Database: 3955/7423 - Release Date: 07/26/14

__._,_.___
Posted by: "David Smart" <smartware.consulting@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)
Yahoo Groups
New feature! Create Photo Albums in Groups Effortlessly
Now, whenever you share photos with your group, a new album is automatically created in the Group. It's so simple! Try it now!
----------------------------------
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

----------------------------------

.

__,_._,___
Diposting oleh EXCEL FEED LEARNING di 01.47

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)