Software

Ask something
Question Locked

Change Check Box Value in Excel 2007

0 helpful
2 replies

by troy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have a very complex excel workbook and I need to create a user friendly front page with check boxes.
the output value is true or false where the rest of my workbook use 1 or 0
is there a way to change the output?

2 replies

by jpp412

in Design mode right click on the checkbox and select view code.

Add the vb code similar to the following:
[Pre]
if (.value) then
Range(" is the name of your checkbox and is "A1" or whatever cell reference as a string.

This discussion is closed to new replies.