Forum Discussion
Changing True/False Result in a linked checkbox cell - Excel 2013
Riny_van_Eekelen Here is the file I am working on. (Highlighted area) (I want the checkbox because I want the manager to check which type of disciplinary form it is, and I don't want the part that says 'Associate ______ was late, etc to show all the time, only if the 'Attendance' box is checked) Appreciate your help!
angiekish121 Your texts are too long to wrap into a single IF function. I made an example of what I meant in cell B21. Split up your texts in separate cells and then use CONCATENATE to combine them into a longer text.
On my way out soon, so will have to continue this tomorrow. If not someone else can resolve this before that!
- angiekish121Mar 04, 2020Copper Contributor
Riny_van_Eekelen I got someone to get it to do what I needed it to do with using Macros. Thanks for your help
- angiekish121Mar 04, 2020Copper Contributor
Riny_van_Eekelen Can you please send me the example you are referencing shown in the excel document? (can you attach it)?