×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Formating TRUE and FALSE as a check box

Formating TRUE and FALSE as a check box

Formating TRUE and FALSE as a check box

(OP)
Once upon a time I did it, but cannot figure it out now. Is it still possible in Office 2003?
thanks a lot!

RE: Formating TRUE and FALSE as a check box

Using the Control ToolBox you can insert a checkbox and then link it to a cell value.  You could then locate the checkbox over the cell of interest.

I'm not aware of anyway to format a cell as a checkbox.

RE: Formating TRUE and FALSE as a check box

The Wingdings font has a nice checkbox, character 111, and with a check mark it is character 254.
So you could format the cell font as Wingdings, and then use something like:
=IF(TRUE,CHAR(254),CHAR(111))

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: Formating TRUE and FALSE as a check box

I think the Forms toolbox is the one you want to get the checkbox from.  The one in the Control toolbox won't let me link it to a cell.  The FORMS toolbox though, it works like a champ... just right click the checkbox once you draw it in and select Format Control at the bottom of the pop-up menu, then the Control Tab and you'll see the Cell Link box.

Should be duck soup from there. ;)

RE: Formating TRUE and FALSE as a check box

Main reason not to use the Forms toolbox is that it is only maintained for compatibility. Good chance that MS will ditch it fairly soon. Also, the items in the Controls toolbox give you more functionality and a complete set of event handlers.
Read more at Jon Peltier's blog (highly recommended anyway)

You can set the LinkedCell property of the control to any cell address, and it will give you the functionality you want.
 

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: Formating TRUE and FALSE as a check box

I still don't get the Control Toolbox version. :shrug:

I found the properties box and typed in a cell for it to link (don't seem to be able to just pick a cell like with the Forms version), but the silly check box won't allow me to check/uncheck.  Whenever I click it, it just lights up the corner "handle boxes" and gives me the 4-point Move Curor.  I can resize and move, but not select.  

If I double click, it opens a VBA module for me.  Nice... I don't need/want VBA, I just want a checkbox linked to a particular cell for True/False.

Same for ComboBox... simple to use with Forms.  Unusable with Controls.  I can draw it and fill in LinkedCell & ListFillRange (I assume that's InputCellRange), but clicking the button after that just lets me stretch &/or move the combobox.  Not much utility in that. :p

Could it be something to do with being stuck using Excel 2000? Or is there some other secret switch I haven't thrown?

RE: Formating TRUE and FALSE as a check box

OH, I found the secret button... you have to UNclick the Design mode button before the object becomes active.

Now I see a difference in the ComboBox tool... The forms version enters a sequential number in the linked cell, the controls version enters a copy of the item selected.  I'm guessing there is a setting to fix that as well, but I haven't stumbled on it yet.

At least I won't be completely in the dark now if the Forms Toolbox dries up and goes away. wink

 

RE: Formating TRUE and FALSE as a check box

(OP)
Thank you for response everyone. I guess it was not excel after all but quatro pro where cell could be formatted and function as a check box. In a relatively large table of changeable size true check boxes (from form or tools toolbars) do not appeal.  

RE: Formating TRUE and FALSE as a check box

How about using data validation?  You could link data validation to a list with a tick and a cross.

Doug Jenkins
Interactive Design Services
www.interactiveds.com.au
 

RE: Formating TRUE and FALSE as a check box

You want an easy way where data moves and resizes in a large table.  

I'm with IDS.  Use data validation.  
Data / Validation / Allow / List (check options "ignore blank" and "in-cell dropdown".

Your list can be two cells containing 0 and 1  or true and false etc.

These are the only things that can be entered. Dropdown menu allows user to select.  Very easy.
 

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Formating TRUE and FALSE as a check box

You could even add some conditional formatting to shade the cell black or white dependent on TRUE or FALSE (1 or 0).

Cheers,
Joerd

Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources