Thread: Forms ComboBox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cmpcwil2[_8_] cmpcwil2[_8_] is offline
external usenet poster
 
Posts: 1
Default Forms ComboBox


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