Formating TRUE and FALSE as a check box

[yakpol]

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

 

[MintJulep]

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.

 

[joerd]

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:
[tt]=IF(TRUE,CHAR(254),CHAR(111))[/tt]

Cheers,
Joerd

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

 

[dgsbsme]

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.

 

[joerd]

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 for tips on how to make the best use of Eng-Tips.

 

[dgsbsme]

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.

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

 

[dgsbsme]

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.

 

[yakpol]

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.

 

[IDS]

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

Doug Jenkins
Interactive Design Services

http://www.interactiveds.com.au

 

[joerd]

sounds like you need Access ;-)

Cheers,
Joerd

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

 

[electricpete]

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.

 

[joerd]

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 for tips on how to make the best use of Eng-Tips.