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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using drop-down list in Excel 2003
Thanks for your help. I already know how to get to the VBA screen. Sorry for not being specific enough...I guess. Im asking for some specific help on how to #1: Create a drop down list in VBA. #2: How to highlight the row that was right clicked with a color corresponding to the item in the list #3 How to call the drop down globally and have it affect only the current row in the current spreadsheet. This is not a paying job for me...only helping a friend on a home application that he wants in order to keep track of jobs around the houses statuses. RED=NEED TO DO, YELLOW=INCOMPLETE, and GREEN=COMPLETE Im capable of working this out alone but just thought to get some help for what seems should be a very easy thing for VBA programmers who do it every day. Thanks again ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using drop-down list in Excel 2003
Debra has some really good info on this
http://www.contextures.com/tiptech.html -- Don Guillett SalesAid Software "ZenX" wrote in message ... Thanks for your help. I already know how to get to the VBA screen. Sorry for not being specific enough...I guess. Im asking for some specific help on how to #1: Create a drop down list in VBA. #2: How to highlight the row that was right clicked with a color corresponding to the item in the list #3 How to call the drop down globally and have it affect only the current row in the current spreadsheet. This is not a paying job for me...only helping a friend on a home application that he wants in order to keep track of jobs around the houses statuses. RED=NEED TO DO, YELLOW=INCOMPLETE, and GREEN=COMPLETE Im capable of working this out alone but just thought to get some help for what seems should be a very easy thing for VBA programmers who do it every day. Thanks again ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using drop-down list in Excel 2003
Thanks a lot. I've done some VB programming back a long time ago. I' just not at all familiar with the objects in spreadsheets. I'llgive this a look. Failing finding a solution with a drop-dow list, I'll just put three columns. T ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
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) |