If statement in VBA

[jts2004]

Here is part of my code. Instead of a checkbox value = true I want a specific cell in my workbook to control the code. EX: if A1= "x" then....

If CheckBox1.Value = True Then
Sheets("Calcsheet").Select
Range("$C$3:$R$3").Select
Selection.Copy

 

[Joe Was]

If CheckBox1.Value = True Then
Sheets("Calcsheet").Select
Range("$C$3:$R$3").Select
Selection.Copy


To:

If [A1].Value = "x" Then
Sheets("Calcsheet").Select
Range("$C$3:$R$3").Select
Selection.Copy

 

[jts2004]

THAT WAS EASY

THANKS