| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Dropdown menu without using the Validation on the Data Menu
Help! I have this huge worksheet with all kinda of formula,look up and dropdown menus. Several of the columns need drop down menus, however I have all ready 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 create 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:BH160 -- lostinformulas ------------------------------------------------------------------------ lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229 View this thread: http://www.excelforum.com/showthread...hreadid=561231 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| How do I get LIST on the DATA menu bar-I need Create List | New Users to Excel | |||
| How do I create a Calendar Drop Down menu for a Validation cell | Excel Worksheet Functions | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
Linear Mode
