Dont want the Checkbox to appear as Boolean statement

[maramiro]

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

 

[Jonmo1]

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","")

 

[Scott Huish]

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.

 

[maramiro]

where could i find the LinkedCell to make it blank??
Thank you

 

[Scott Huish]

When you're in Design mode. Right click the control and click on Properties