VBA and Macros to build a Combo Box powered schedule

**aperiogaming** · 12-16-2019, 08:38 AM

Hi All!

First post here.

I need to optimise a schedule/location planner for staff at work, and it'll ideally involve three Combo Box elements: select name, select date, select location. Each corresponding selection will highlight (and with the final selection, amend) a cell in a pre-defined monthly calendar.

Is this do-able?

In the image below, the boxes I'm referring to are highlighted.

Planner.PNG

Thanks very much, everyone.

**Pepe Le Mokko** · 12-16-2019, 09:12 AM

Hi
please read the yellow banner. thx

**aperiogaming** · 12-16-2019, 09:40 AM

Hi Pepe

Thanks for amending.

I don't really have any example to show - the image is just a basic sheet with conditional formatting, no macros, VBA or anything concrete.

It's more a question of "is this possible" as opposed to "here is what I have, does this work?"

Thanks

VBA and Macros to build a Combo Box powered schedule

LinkBack

Thread Tools

Rate This Thread

Display

VBA and Macros to build a Combo Box powered schedule

Re: New to Excel - need to use VBA and Macros to build a Combo Box powered schedule

Re: VBA and Macros to build a Combo Box powered schedule

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Build rotating schedule and skip last Sunday of every month

Auto Reminder mail from Excel when the PC is powered on or signed in

Insert various shapes to build a schedule

Trying to build an automated schedule

[SOLVED] Lookup Formula with 2 criteria to build schedule

Creating a Build Schedule

Help me to build IF function for my production schedule>>>URGENT>>>>

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions