adding dropdowns (multiple columns) into calendar

[Hank Moore]

Wanting to create a working calendar where I can show the job name, address, and work to be performed plus have two dropdowns for the technicians that will be performing the work and one showing which vehicle(s) that will be used. an example is attached.

I've created the macro (copied off microsoft's site) for the calendar but don't know how to make two additional columns inside each day to accommodate the dropdowns. Is it possible to do this? The job portion would be manually entered. More than likely there will be the need to add more columns i.e., for certain tools or material needed for that particular job.

 

[David Evans]

Hank -

Take a look at the attached file. I think this is the sort of thing you're trying to achieve.
I didn't use the Visual Calendar - I find them to be fraught with issues, tbh. I have a table create a dynamic Calendar listing and use that to feed the dropdown.
The Jobs tab has an Excel Table on it - named tblJobs. In that table are dropdowns for Date, Techs, Vehicle and Tools. Play with it and see what needs to be tweaked.