if Criteria equals set tick box to true, is it possible

[ShirleyC]

Hi I am looking for a formula for the following?

If g11="discount" set a tick box in g13 to true

Is this possible?

Thanks in advance
Shirley

 

[lenze]

Why do you need a Tick Box in G13? Can you not use the word "True" or perhaps a simulated checkbox?

lenze

 

[ShirleyC]

As part of A/S level coursework pupils must include a tick box and thought it would be a better use than simply manually ticking it

 

[MickG]

Hi, This is not a formula, But you might get some Brownie points with this, then again maybe not.
One code is for "Forms" Tick Box and the Other for "ActiveX" (View, "ToolBar", "Control ToolBox").
Place a Tick Box on sheet, Right Click "Tab" Select "View Code" Paste Either code (depending) in VB Window.
Close VB Editor, run code by inserting/removing "discount"

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("G11").Value = "discount" Then
 ActiveSheet.Shapes("Check Box 4").ControlFormat.Value = False
Else
ActiveSheet.Shapes("Check Box 4").ControlFormat.Value = True
End If

If Range("G11").Value = "discount" Then
CheckBox1.Value = True
Else
CheckBox1.Value = False
End If
End Sub

Regards Mick

 

[ShirleyC]

tried it and it works a treat, fantastic

Thanks