Hiding a checkbox (EXCEL 97/2000)

Topic

New Reply

Have a workbook which is acting like -sort of- a form. Still (!) have not used any VB-code [it’s beginning to look like sort of an art ], while the form adapts very nicely to the supplied input (I’m using mostly fomulas, conditional formatting & validation).

Now I want to display a check-box in some cases (I’ll not do anything with the actual selection, it is just there for display)… are there ways to show and hide these as well without using VB-code???

Erik Jan

Reply | Quote

Replies

I don’t know of a way to hide or show a check box without using VBA…

Reply | Quote

Use this formula (value for checkbox is in cell B2) and format the cell with the wingdings font:

=IF(B2=1;”

Reply | Quote

Nifty!

Reply | Quote

Funny what I learn from Woody’s Lounge. I just learned that apparently there is a difference between the European & US versions of Excel in how formulas are delimited. I pasted the above formula [=IF(B2=1;”

Reply | Quote

It’s not the version of Excel, but the user’s Regional Settings that make the difference. In The Netherlands, where Jan Karel Pieterse and I live, the comma is used as decimal separator (and the period as thousands separator), so another character had to be used as “list separator”: the semicolon. In other European countries, it may be different.

Reply | Quote

Oops, sorry ’bout that. Usually I first S&R semicolons for commas before posting.

Reply | Quote

Thanks for the tip (I had to change the formula too… even though I’m Dutch and living in the Netherlands, my computer is set-up the US-way..).

Anyway, although the tip works, it is not exactly what I was looking for (re-reading my original request, I realize now I might not have formulated carefully enough… I apologize), I’ll try to clarify:

* I would like people to make a selection using a checkbox (so they would have to check/uncheck the box)

* I am not going to do anything with the selection (checked/unchecked), so there’s no direct need for a ‘linked cell’

* I don’t want to use code (VBA/macro)

That’s all still simple, right? Now here’s my last wish:

* I want some checkboxes only to become visible if another cell has a certain value in it….

Example?

Question 1: Are you older than 20?

Question 2: What’s your weight?

Now, ONLY if one answers YES to question 1, I want a new question (1a) to pop-up:

Question 1a: Click the check-box if you are under 40 (shows a checkbox).

How do I hide/unhide this question 1a, depending on the reply to question 1?? Is that possible?

Thanks!

…

Reply | Quote

I do not think you can hide and unhide working checkboxes without code.

You can hide and unhide TEXT by adding text into a textbox linked to a cell and the cell contents can be tied to an if statement to show NOTHING (null string = “”) or other text.

Steve

Reply | Quote