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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
When you're in Design mode. Right click the control and click on Properties
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,850
Members
414,342
Latest member
K Darrell Smith

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
Top