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!
thanks a lot!
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Formating TRUE and FALSE as a check box
|
RE: Formating TRUE and FALSE as a check box
I'm not aware of anyway to format a cell as a checkbox.
RE: Formating TRUE and FALSE as a check box
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
Should be duck soup from there. ;)
RE: Formating TRUE and FALSE as a check box
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 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
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.
RE: Formating TRUE and FALSE as a check box
RE: Formating TRUE and FALSE as a check box
Doug Jenkins
Interactive Design Services
www.interactiveds.com.au
RE: Formating TRUE and FALSE as a check box
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'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
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.