Create Dropdown menu without using the Validation on the Data Menu

Help!

I have this huge worksheet with all kinda of formula,look up an
dropdown menus.

Several of the columns need drop down menus, however I have all read
used the Validation to create a error message with cusom formulas.

I think I have seen that there is a webpage that tells how to creat
the dropdown menus in VB.

My drop down menu are simple
Worksheet name: 1
HB or a blank cell would go into columns BC17:BC160,BD17:BD160
EXPRESS or a Blank cell would go into colums BE17:BE160,BF17:BF160
HBX or a Blank Cell would go into coulumns BG17:BG160,BH17:BH16

--
lostinformula
-----------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...fo&userid=3522
View this thread: http://www.excelforum.com/showthread.php?threadid=56123