Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box problem
I'm using a check box to return a value and that part works OK, but in the
cell that the box is in is showing the words True or False behind the box. How do I get rid of this?? Thanks for any help -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200706/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box problem
Remove the cell link if you want.
If you need to keep the information, but don't want to see it, you could use a cell link in a different cell (hidden or far away) or you could give that cell a custom format: format|cells|Number tab|Custom category ;;; (3 semi colons) The value will still be there (visible in the formula bar) and you can use it other formulas, but it'll look blank in the worksheet. "bhrosey via OfficeKB.com" wrote: I'm using a check box to return a value and that part works OK, but in the cell that the box is in is showing the words True or False behind the box. How do I get rid of this?? Thanks for any help -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200706/1 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check box problem
Dave Peterson wrote:
Remove the cell link if you want. If you need to keep the information, but don't want to see it, you could use a cell link in a different cell (hidden or far away) or you could give that cell a custom format: format|cells|Number tab|Custom category ;;; (3 semi colons) The value will still be there (visible in the formula bar) and you can use it other formulas, but it'll look blank in the worksheet. Thanks, that helped a lot!!! I'm using a check box to return a value and that part works OK, but in the cell that the box is in is showing the words True or False behind the box. [quoted text clipped - 5 lines] Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200706/1 -- John 3:16 "For God so loved the world that He gave His only begotten Son, so that whoever believes in Him shall not parish, but have eternal life" Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200706/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check box cell link - copy problem | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Problem with validation check! | Excel Worksheet Functions | |||
Problem Deleting Check Boxes created from Forms Toolbar | Excel Discussion (Misc queries) |