Combo Boxes and Tick Boxes

[turner2000]

Hey,

I'm trying to create a workbook where in say column B there is a comb
box in every cell that has something else in that row. I want th
linked cell of that combo box to be the cell the combo box is in bu
there will be hundreds of records.

How can I put a combo box or a tick box in every cell in a certai
column without having to do each one manually? I only want them t
appear in that particular row once something has been entered into th
A column and I have tabbed across.

Is this possible?

Thanks in advance!
-turner200

 

[Anne Troy]

Why use a combo box? Why don't you just use Data-Validation?
http://www.theofficeexperts.com/excel.htm#DropdownLists
It is *usually* all that anyone needs.

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************