Thread: too many combos
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VOG VOG is offline
external usenet poster
 
Posts: 1
Default too many combos


Hi,
I am trying to work with a workbook that has one sheet containing
nearly 100 combo boxes. Each row would contain about 8 boxes that allow
the user to select info.

The sheet itself was not designed by me and redesigning is a not an
option.

Is there a way to go through each combo box by row and retrieve its
info without having to reference them by name..

Eg
Start at row 1
Take information from the combo box at A1, B1, C1, D1 etc then
Then move to row 2 until end of the rows I specify.


--
VOG
------------------------------------------------------------------------
VOG's Profile: http://www.excelforum.com/member.php...o&userid=28079
View this thread: http://www.excelforum.com/showthread...hreadid=475867