| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
too many combos
Why not create an array that holds the data the way you want. Then loop
through all the comboboxes and populate the array. How you loop would depend on the type of combobox you are using. Which type: Forms Toolbar Control Toolbox Toolbar Data Validation -- Regards, Tom Ogilvy "VOG" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| table of # of rows with unique combos of values in 4 separated col | Excel Worksheet Functions | |||
| Comparing two combos/cells to return a value | Excel Worksheet Functions | |||
| Entering combos without converting it to dates? | Excel Discussion (Misc queries) | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
| one sub for many Combos in different way | Excel Programming | |||
Linear Mode
