Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |