Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding a checkbox (EXCEL 97/2000)

    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 <img src=/S/artist.gif border=0 alt=artist width=34 height=29>], 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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

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

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

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

    =IF(B2=1;"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

    Nifty!

  5. #5
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

    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;"

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

    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.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

    Oops, sorry 'bout that. Usually I first S&R semicolons for commas before posting.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

    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....

    <font color=blue> Example?

    Question 1: Are you older than 20?

    Question 2: What's your weight?
    </font color=blue>

    Now, ONLY if one answers YES to question 1, I want a new question (1a) to pop-up:
    <font color=blue>
    Question 1a: Click the check-box if you are under 40 (shows a checkbox).
    </font color=blue>

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

    Thanks!

    ...

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Hiding a checkbox (EXCEL 97/2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •