Formula for tickbox?!?
 

:confused:
Is there a formula to add a tick in the tickbox if there is dat
present in another cell? Does this sound confusing

--
Mario Londo
-----------------------------------------------------------------------
Mario London's Profile: http://www.excelforum.com/member.php...fo&userid=1572
View this thread: http://www.excelforum.com/showthread.php?threadid=27246

Formula for tickbox?!?
 

Mario,

One way is to use this technique of having a check column, and
monitoring it with a worksheet selection change event. Add your code as
needed.

So if we assume that the data is in A1:A100 (change to suit), clicking in
column A will do what you want with this code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo sub_exit
If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
With Target
If .Value = "a" Then
.Value = ""
Else
.Value = "a"
.Font.Name = "Marlett"
End If
.Offset(0, 1).Activate
End With
End If
sub_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--

HTH

RP

"Mario London" wrote in message
...

:confused:
Is there a formula to add a tick in the tickbox if there is data
present in another cell? Does this sound confusing?


--
Mario London
------------------------------------------------------------------------
Mario London's Profile:
http://www.excelforum.com/member.php...o&userid=15726
View this thread: http://www.excelforum.com/showthread...hreadid=272468

Formula for tickbox?!?
 

Set the LinkedCell property of the checkbox to A1 or whatever cell it is to
be linked to.
If the cell value is True the checkbox will be checked, if False it will be
unchecked.
I believe 1 and 0 can be sunstituted for True and False respectively.
HTH
Chris

"Mario London" wrote in message
...

:confused:
Is there a formula to add a tick in the tickbox if there is data
present in another cell? Does this sound confusing?


--
Mario London
------------------------------------------------------------------------
Mario London's Profile:
http://www.excelforum.com/member.php...o&userid=15726
View this thread: http://www.excelforum.com/showthread...hreadid=272468