Hi, I know how to find the cell address of a given
vb combobox and the
set the offset....
ActiveSheet.OLEObjects("combobox 1").TopLeftCell.Offset(0, 1 + i)
But how do you do this for a form ComboBox?
I have tried declaring a combobox object but there is no TopLeftCell
do you have to use the linked cell property and then change th
activecell property?
Thank
--
cmpcwil
-----------------------------------------------------------------------
cmpcwil2's Profile:
http://www.excelforum.com/member.php...fo&userid=3341
View this thread:
http://www.excelforum.com/showthread.php?threadid=53446