• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic dropdowns incl. multiple selections

K

Kasper Devald

New Member
Hi all,

I need your help with some VBA coding that I'm been struggling with over some time. I have created a workbook where you are able to select multiple or single weekdays and based on the input you should be able to choose that single day or days activities.

I have been able to solve the multiple selection but are having difficulties for the VBA code to accept the validation I have made. I have attached my test workbook as an example.

I really hope that someone is able to help or guide me as I have tried to long now without any break through.

/Kasper
 

Attachments

  • Weekday activities incl. new lookup.xlsm
    34.7 KB · Views: 4
Last edited:
Hi Kasper ,

The problem is the DV rule , which merely has =DayList ; this is just a list of days , without concatenation of more than 1 day.

When you select multiple days , the output of the code is a concatenated value separated by a comma ; this will clearly not be accepted by the DV rule.

The DV rule has to be changed.

Can you indicate how many days you will eventually have ? All 7 of them ?

Narayan
 
Hi Kasper ,

See if this is OK ; I have made the changes only for the Weekday column.

Narayan
 

Attachments

  • Weekday activities incl. new lookup1.xlsm
    36.7 KB · Views: 12
Hi Narayan,

sorry for my late reply :( But thank you for your input it really helped me on the right track. I ended up having to modify my VBA codeing a little bit, but now it's working :)
 
You must log in or register to reply here.
Back
Top