Multiple checkbox inside a cell

[ChrissyJ4]

Hi

I am trying to create a checkbox for multiple lines inside a cell.
Essentialy a to-do list.
Im using a calendar to visually list tasks for each day based on what work day it is for and end of month task list.

Currently I have inserted a special character in my text (which services as a place marker that shows on the vlookup cell result see "text view" image) from where my vlookup references from.

After this I place a radio button on each line manually in the vlookup cell in the calendar's face and have to set alignment each manually.
This is a repetitive task but each time the timing of task is different so the list varies. It's tedious to reset each month.

Is there a way I can replace the special character in my text with a radio button? so that it automatically aligns each time?
Or achieve the same result a different way?
or if there a ready built excel template someone know about that achieves something similar?

My macro skills are very basic.
Thanks in advance for any help.

 

[6StringJazzer]

Do all the lines have to be in once cell? Can you modify your design to have one line per cell?

It might be possible but rather difficult to insert option buttons that would align to the lines of text.

This kind of thing is done more easily in apps designed for tasks and calendars, like Outlook. Have you considered doing this in a different app?

 

[ChrissyJ4]

Do all the lines have to be in once cell? Can you modify your design to have one line per cell?

It might be possible but rather difficult to insert option buttons that would align to the lines of text.

This kind of thing is done more easily in apps designed for tasks and calendars, like Outlook. Have you considered doing this in a different app?

The number of text lines changes each month but it is possible to split each lines out but would have to reformulate each month each day every time its rolls over.
The only available apps to me have either have no automation of the tasks per day (ie one note) or cannot be viewed holistically (eg. gantt chart or calendar like outlook) . What apps do you suggest where team collaboration can still occurr? I have used Wrike before but that is just not an option at my current workplace as they have their own project managed app but sadly the one they use isnt visually helpful.

 

[6StringJazzer]

How are you doing team collaboration with Excel?