Thread: DROP DOWN LIST
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Heidenreich Corey Heidenreich is offline
external usenet poster
 
Posts: 6
Default DROP DOWN LIST

Hey All,
I'm a little stuck in a programming frenzy here.

I know how to make a drop down list and how to validate and so on.

Anyway this is what I'm looking for:

Drop Down List Names:
Bill (Needs to be a value of 1 upon selection but still show the
name Bill)
Bob (Needs to be a value of 2 yada yada yada)
Sam (Needs to be a value of 3)

.........and so on.
This way I can take the number of times Bill did something and total them
together.

Just don't know how to get dual values on 1 drop down list.

Corey
MCP