EXCEL97 Combobox ListfillRange

[harwooddale]

I have created a combobox and want to fill it with data from more than one range. I know how to select data from one rane ie [sheet!$A$1:$A$2], but how would i add another range?
Any help would be appreciated!!!

 

[mmtraining]

Simplest way is to cheat and use a new sheet and get the information out of the other two or three sheets using ='SheetName'!A1 and drag down from the corner as far as needed (in your example just one more cell) then under that (for example) ='NameOfOtherSheet'!B12 and drag down as far as needed.

Then use that range to hand the data onto the combo box. To stop the users from deleting the sheet with the collected info on it, hide it. Some users get very pernickity about the number of sheets, rows or columns and decide to tidy up a bit.

I'll keep an eye on this thread to see if anyone knows the "real" way of doing it.

All the best,

Carol
Berlin, Germany

 

[harwooddale]

Carol,
thanks for your tip. I will try it out. It just seems so simple really, we totally overlooked it.

Regards

James