| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using drop-down list in Excel 2003
Hello, I have volunteered to help a friend and, having not done much VBA came here for help. I am a programmer...for over 25 years..just no with VBA, so don't baby me. lol I would like to use VBA with Excel 2003 to trap the BeforeRightClic event. In my vision, doing so (rt-click) anywhere in the workbook will bring up a drop-down list with 3 items in it. I would like t highlight the current row with one of 3 colors, depending on which lis item is clicked. There will be from 1 to n sheets in the workbook so the module shoul be global but affect only the current row in whatever sheet tha currently has focus. Any help or suggestions will be greatly appreciated. TIA, Zen ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - Drop Down list based on another cell value | Excel Discussion (Misc queries) | |||
| Excel 2003 - Drop Down List | Excel Worksheet Functions | |||
| How to Edit an Exisiting Drop-Down List in Excel 2003 | Excel Discussion (Misc queries) | |||
| excel 2003, ,,list drop-down arrow not visable | New Users to Excel | |||
| How do I create a drop down list in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
