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.
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.