Forum home » Delegate support and help forum » Microsoft Excel Training and help » Check boxes

Check boxes

ResolvedVersion 2007

Mon 14 Feb 2011, 16:21 Delegate Lucy said...

Lucy has attended:
Excel VBA Intro Intermediate course

Check boxes

When you have a control form check box linked to a cell, it shows "FALSE" or "TRUE" in the cell behind the check box. Is it possible to turn this off so that all you see is the check box with or without the tick in it?

Thanks

Thu 17 Feb 2011, 12:00 Trainer Stephen said...

RE: Check boxes

Hi Lucy

Thanks for your question

I'm not sure I follow you in that the behaviour you describe is not something I can replicate, and is not what I would expect

Could you email me a copy of the file so I can investigate further

My email is sw@stl-training.co.uk

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips

Check boxes

Check boxes

RE: Check boxes

Excel articles

Excel tip:

Adding up time greater than 24 hours