How can I get a Checkbox to reverese its function.
I have a check box linked to a cell and want the box to be checked when the cell is False, and clear the cell is True.
Any help appreciated.
How can I get a Checkbox to reverese its function.
I have a check box linked to a cell and want the box to be checked when the cell is False, and clear the cell is True.
Any help appreciated.
Assuming checkbox is from Forms toolbar, not control toolbox:
Substitute your linked cell's address, the sheet name, and the CheckBox name
in the below:
Sub CheckBox1_Click()
Range(LinkedCell).Value = (Sheets("Sheet1").Shapes("Check Box
1").ControlFormat.Value <> 1)
End Sub
If you also need the checkbox to update when the user changes the value in
the linked cell, you would need to do this as well in the Worksheet's code
module:
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Range(LinkedCell).Value
Case True
Sheets("Sheet1").Shapes("Check Box 1").ControlFormat.Value = -4146
Case False
Sheets("Sheet1").Shapes("Check Box 1").ControlFormat.Value = 1
End Select
End Sub
"Donkin" wrote:
>
> How can I get a Checkbox to reverese its function.
>
> I have a check box linked to a cell and want the box to be checked
> when the cell is False, and clear the cell is True.
>
> Any help appreciated.
>
>
> --
> Donkin
> ------------------------------------------------------------------------
> Donkin's Profile: http://www.excelforum.com/member.php...o&userid=23715
> View this thread: http://www.excelforum.com/showthread...hreadid=375694
>
>
I'd use a helper cell and a formula that checked that linked cell:
If A1 is the linked cell, then I'd put this in B1:
=not(a1)
Then use B1 for anything that I needed (hide column A if you want).
Donkin wrote:
>
> How can I get a Checkbox to reverese its function.
>
> I have a check box linked to a cell and want the box to be checked
> when the cell is False, and clear the cell is True.
>
> Any help appreciated.
>
> --
> Donkin
> ------------------------------------------------------------------------
> Donkin's Profile: http://www.excelforum.com/member.php...o&userid=23715
> View this thread: http://www.excelforum.com/showthread...hreadid=375694
--
Dave Peterson
Thanks Guys but I couldn’t get your suggestions to work but my solution is:-
Forms Checkbox which is linked to Cell B1
The Checkbox is assigned a Macro which inputs a formula into cell A1
The Macro then inputs an IF function into Cell B1 with IF(A1=”Formula”,True,False)
If the formula is in A1, B1 returns True which Checks the Checkbox
If the User has inputted a Value in A1, B1 returns False and due to the IF function Checkbox, unchecks itself.
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks