ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Checkbox value displays as text on the cell underneath it (https://www.excelbanter.com/excel-discussion-misc-queries/147423-checkbox-value-displays-text-cell-underneath.html)

lillyanka

Checkbox value displays as text on the cell underneath it
 
I would like to know what I can do to keep the cell under my checkbox from
displaying the CK value ("TRUE" or "FALSE").

Can somebody help me out with that?

Peo Sjoblom

Checkbox value displays as text on the cell underneath it
 
Link to a cell in a column that is hidden instead or use white fonts


--
Regards,

Peo Sjoblom



"lillyanka" wrote in message
...
I would like to know what I can do to keep the cell under my checkbox from
displaying the CK value ("TRUE" or "FALSE").

Can somebody help me out with that?




lillyanka

Checkbox value displays as text on the cell underneath it
 
That did not occur to me. Thanks so much!

Dave Peterson

Checkbox value displays as text on the cell underneath it
 
I like to use a custom numberformat of: ;;;
(3 semicolons)



lillyanka wrote:

I would like to know what I can do to keep the cell under my checkbox from
displaying the CK value ("TRUE" or "FALSE").

Can somebody help me out with that?


--

Dave Peterson

lillyanka

Checkbox value displays as text on the cell underneath it
 
Could you explain that to me? Heehee.

"Dave Peterson" wrote:

I like to use a custom numberformat of: ;;;
(3 semicolons)



lillyanka wrote:

I would like to know what I can do to keep the cell under my checkbox from
displaying the CK value ("TRUE" or "FALSE").

Can somebody help me out with that?


--

Dave Peterson



All times are GMT +1. The time now is 01:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com