Comob Box Help

Ronky

New Member
Joined
Oct 16, 2006
Messages
2
I have a sheet that contains 20 cells of data in a list that alter based on input data on other sheets. I wish to create a combo box on a new sheet as a way of viwing a choice but as the data input can represent zero values in my list, I wish to create a combo box that only displays the positive data and excludes the zero fields.

Can anyone advise the best method for this? A formula or set of formulae or perhaps some VBA code?

Please help.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,114,281
Messages
5,546,954
Members
410,764
Latest member
Dedeke
Top