We help IT Professionals succeed at work.

Excel Dropdown list.  Multiple items in a string

95 Views
Last Modified: 2016-07-12
In the attached file:
DropDown sheet contains 2 Named Ranges
1. DaysOfWeek in Col A
2. Daily Start Times in Col B


STudentRoster contains 3 Named Ranges
1. Student Name in Col A       eg. AAA
2. Days Attending  in Col B     eg MonWedFri
3. Daily End Time in Col C       eg  1500

For each Student I want to be able to select:
1.  multiple Days from Days of Week (in DropDowns sheet) ,  concatenate the Days selected  and enter the  result in Days Attending (Student Roster sheet)

2. Select a value from Daily End Times (in DropDowns sheet) and enter the value in
   Daily End Time (in Student Roster sheet)

A VBA solution would be preferable

Thanks
Ed
Comment
Watch Question

AndyAinscowFreelance programmer / Consultant
CERTIFIED EXPERT

Commented:
ps.  EE is for asking questions about how to do something.  It isn't a place to give an 'order' for a piece of code.
Explaining what bit you can't do is also useful.

Author

Commented:
Sorry. I didn't intend to mean it as an "order" Any advice as to how to achieve the results I'm looking for would be great.

Ed
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
Ed,
The different Topic Areas may have different expectations regarding coding.

AndyAinscow is very active in Kernel And Operating System Specific Programming and in Windows MFC Programming, and has a Genius rating in each. I'd be quite willing to believe that the expectation is that people posting in those TAs have a full-time job doing programming, so they are looking for a tip or advice on overcoming a vexing issue.

I am active in the Excel, and in that TA we are much more willing to write short macros for people. The definition of short will vary with the Expert, but most of us are willing to write up to a hundred lines of code or so. That ought to be enough for your immediate task.

The starting point, however, is for you to specify which version of Excel you are using, and to post a sample workbook showing sample inputs and desired results. In this case, data for 3 imaginary students ought to suffice.

Brad

Author

Commented:
Hi Brad:
Thanks for the tip.
In the attached sheet, I've included an explanation of what I'm trying to accomplish.
Hope this is what you're looking for.
Again, thanks.
Ed
AndyAinscowFreelance programmer / Consultant
CERTIFIED EXPERT

Commented:
Nicely put Brad, that is part of it.
Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime.

I strongly believe it is best to try first oneself and be given advice on the bits one can't achieve.  It is so easy to say I'll study the code tomorrow when given a complete solution.
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
Ed,
While you may have tried twice, you haven't actually succeeded in attaching a workbook.

Please review the step by step instructions in my opening Comment.

Brad

Author

Commented:
Brad:
Thought I was doing it as u told me but guess not.
Any, I hope you got what I just sent. May have sent more than one. Sorryfor the agg.
Ed


<<Ed subsequently mailed byundt the file. He attached it at 6:20 PM CST on 12/30/13>>
MultiSelectDropDownQ28327236.xlsx
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
Ed,
If you email the file to me, I'd be glad to post it for you. My address is my screen name at Experts-Exchange.com

If you have already done so (as of your latest Comment), please double-check the address as I have not received it.

Brad
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
Ed,
I got the file and (wearing my Topic Advisor hat) attached it to your last Comment.

Brad
Mechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
When I try to open the file I get a message:

"The Visual Basic Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one."

Author

Commented:
OK. Did a repair on Office and rebooted. Seems to have cleared it up.
I'll work with it and get back to you
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
This question was answered by code (and a sample workbook) posted in https:#a39747558 

The proposed solution is written in VBA (as requested) and satisfies both objectives requested in the question body.

I just downloaded the workbook and confirmed that it works exactly as claimed.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.