Forum Discussion
angiekish121
Mar 03, 2020Copper Contributor
Changing True/False Result in a linked checkbox cell - Excel 2013
I am trying to change the default True/False responses to a linked checkbox in excel to something else, how do I go about that? I also don't want to use a formula, as I want to be able to edit the li...
Riny_van_Eekelen
Mar 04, 2020Platinum Contributor
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!
angiekish121
Mar 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