Excel Help - Check box and hiding cells

Excel Help - Check box and hiding cells

Didn't find your answer?

Hello all,

I just wondered whether anyone could help with an excel query. I have a form that I have created in excel with some check boxes.

What I would like to know is whether it is possible to hide cells if the check box is unticked and then show the cells for editing when it is ticked. This would all have to be done without using VBA!

Regards, Richard

Replies (3)

Please login or register to join the discussion.

By bro0010
19th Nov 2014 14:56

A possible solution

Hi Richard,

I've mocked up a demo which I can send you if you PM me with an email.

The basic approach is to put a checkbox in Excel and drive a combination of conditional formatting and data validation from the cell link for the check box.

The cells are hidden by setting the font colour to the same as the background colour using conditional formatting. Data validation prevents entry in the same cells unless the checkbox is ticked (True).

I hope this will be sufficient for your needs.

Warm regards,

Ian

Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel to go

Thanks (1)
avatar
By Rikos
20th Nov 2014 11:54

Thank you

Hello Ian,

Thank you for the idea, I can give that a whirl as understand what you mean. I am sure that will work fine.

Thanks (0)
avatar
By edhy
22nd Nov 2014 06:02

Why No VBA

It is quite simple with VBA.

Use worksheet change event and check value of link cell of the checkbox to execute the code.

Regards

Zubair Edhy

 

Thanks (0)