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

DROP DOWN LIST
 

i've used something like this for using months in the dropdown. i set it as
a counter because i needed to subtract months for beginning and ending
periods to create how many times the loop ran. you should be able to set
variables to the person's name.

in my dropdown, i used a variable called speriod to store the value in the
cell containing the dropdown, January 2005, february 2005 and so on. then i
set the speriod end variable with this:sPeriodEnd = Left(Speriod, 3) (the
sheetnames are 3 characters)

hopefully this will help you.

If sPeriodEnd = "Jan" Then
cntE = 1
ElseIf sPeriodEnd = "Feb" Then
cntE = 2
ElseIf sPeriodEnd = "Mar" Then
cntE = 3
ElseIf sPeriodEnd = "Apr" Then
cntE = 4
ElseIf sPeriodEnd = "May" Then
cntE = 5
ElseIf sPeriodEnd = "Jun" Then
cntE = 6
ElseIf sPeriodEnd = "Jul" Then
cntE = 7
ElseIf sPeriodEnd = "Aug" Then
cntE = 8
ElseIf sPeriodEnd = "Sep" Then
cntE = 9
ElseIf sPeriodEnd = "Oct" Then
cntE = 10
ElseIf sPeriodEnd = "Nov" Then
cntE = 11
ElseIf sPeriodEnd = "Dec" Then
cntE = 12
End If

--


Gary


"Corey Heidenreich" wrote in message
...
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

DROP DOWN LIST
 

Hello Gary,
Thanks for the info.
I'm still having some problems with the programming of it though
Here's my example

Team 1 Team 2 Team 3
C1 s1 f1
c2 s2 f2
c3 s3 f3
s4 f4
f5
f6



Team selection dd1
Member dd2

note: dd=dropdown

Both of the 2 above blanks are dropdowns.
The highlighted yellow is grouped as "Teams"
I have C1:C3 grouped as "Team1"
I have S1:S4 grouped as "Team2"
I have F1:F6 grouped as "Team3"
Currently Team Selection dd1 is validated as "Teams" which allows you to see
Team 1, Team 2, and Team 3 labels in the drop down
Then the members dropdown (dd2) is validated as =INDIRECT(dd1). So
whichever Team I select, it will give the correct team members for that
selection.
I just need the option to set a value to each team member (i.e. c1 = 20, c2=
21, c3 = 22, s1 = 23, etc.)

Hope this helps clarify where I'm going with this.

Corey








"Gary Keramidas" wrote in message
...
i've used something like this for using months in the dropdown. i set it
as a counter because i needed to subtract months for beginning and ending
periods to create how many times the loop ran. you should be able to set
variables to the person's name.

in my dropdown, i used a variable called speriod to store the value in the
cell containing the dropdown, January 2005, february 2005 and so on. then
i set the speriod end variable with this:sPeriodEnd = Left(Speriod, 3)
(the sheetnames are 3 characters)

hopefully this will help you.

If sPeriodEnd = "Jan" Then
cntE = 1
ElseIf sPeriodEnd = "Feb" Then
cntE = 2
ElseIf sPeriodEnd = "Mar" Then
cntE = 3
ElseIf sPeriodEnd = "Apr" Then
cntE = 4
ElseIf sPeriodEnd = "May" Then
cntE = 5
ElseIf sPeriodEnd = "Jun" Then
cntE = 6
ElseIf sPeriodEnd = "Jul" Then
cntE = 7
ElseIf sPeriodEnd = "Aug" Then
cntE = 8
ElseIf sPeriodEnd = "Sep" Then
cntE = 9
ElseIf sPeriodEnd = "Oct" Then
cntE = 10
ElseIf sPeriodEnd = "Nov" Then
cntE = 11
ElseIf sPeriodEnd = "Dec" Then
cntE = 12
End If

--


Gary


"Corey Heidenreich" wrote in message
...
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