Using drop-down list in Excel 2003

[ZenX]

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

 

[Don Guillett]

To get you started>right click the excel logo just to the left of FILE>in
the left drop down select workbook>in the right drop down select>sheet
before right click

 

[ZenX]

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

 

[Don Guillett]

Debra has some really good info on this
http://www.contextures.com/tiptech.html