Check Box if a Cell Contains a Value

[BillyK66]

Hi
I'm trying to set up what I though would be a fairly straightforward check/tick box, so if a specific cell has a value in it (any value) a check box is ticked.
Even better would be if the cell had no value entered the box returns an 'x'.
Don't know if this is possible?
Just for info, when it comes to VBA I don't believe I know enough to even call myself a Novice!
Many Thanks

 

[Anthony47]

In a cell insert this formula:

=IF(A1="","x","þ")

Modify A1 to the address of the "specific cell" you wish to monitor, then format the cell with the font Wingdings
Try...

 

[BillyK66]

That's great thanks! Does a good enough job for what I need

 

[Anthony47]

Thank you for the feedback
If that resolve the problem then it'd be better to mark the discussion as Resoved; see the procedure: Mark as Solution