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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,875
Members
409,843
Latest member
akostaki
Top