Dont want the Checkbox to appear as Boolean statement

maramiro

Board Regular
Joined
Mar 17, 2009
Messages
67
I have a userform with a checkbox.
when the results appear on the worksheet, the checkbox appears as a boolean statement.
if it is checked, it shows as "true" and is not, it shows as "false".
i dont want it to show as boolean statement, how can i change it to show "X"when it is checked, and leave the cell blank when it is not checked.
Thank you
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
You can't..at least as far as I know...
That's how checkboxes work..

What you CAN do...
is HIDE the column that is returning the True False, and use another column to show x or blank based on the original column..


If the CheckBox is putting True/False in say A1,
Then Hide column A, and in B1 put
=IF(A1,"x","")
 
Upvote 0
If this is actually on the spreadsheet, and you are using an ActiveX control checkbox, go in to properties and make sure LinkedCell is blank.
 
Upvote 0
When you're in Design mode. Right click the control and click on Properties
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top