values – MYSYNTAX: VBA

What is the syntax to see if a checkbox is checked?

 <userform name>.<checkbox name>.Value

'example
If formHome.chkActiveOnly.Value = True Then
    MsgBox "User has checked the box"
Else
    MsgBox "User has not checked the box"
End If

What is the syntax to write to another workbook?

'to retrieve data
Workbooks("<workbook file name>").Worksheets("<sheet name>").Range("<your range>").Value
Workbooks("<workbook file name>").Worksheets("<sheet name>").Cells(<row number>, <column number>).Value

'to set data
Workbooks("<workbook file name>").Workbooks("Worksheets("<sheet name>").Range("<your range>") = <your value/data>
Workbooks("<workbook file name>").Worksheets("<sheet name>").Cells(<row number>, <column number>).Value = <your value/data>

'examples
Workbooks("example.xlsm").Worksheets("Example").Range("A1:A4") = "hello"
Workbooks("book3.xlsx").Worksheets("Example").Range("D1") = "world"
Workbooks("book3.xlsx").Worksheets("Example").Cells(2, 4).Value = "goodbye"

What is the syntax to use/set data in another sheet?

'to retrieve data
Worksheets("<sheet name>").Range("<your range>").Value
Worksheets("<sheet name>").Cells(<row number>, <column number>).Value

'to set data
Worksheets("<sheet name>").Range("<your range>") = <your value/data>
Worksheets("<sheet name>").Cells(<row number>, <column number>).Value = <your value/data>

'examples
Worksheets("Example").Range("A1:A4") = "hello"
Worksheets("Example").Range("D1") = "world"
Worksheets("Example").Cells(2, 4).Value = "goodbye"

What is the syntax to format borders?

Range(“<cell reference>”).Borders.LineStyle= <line style>
Range(“<cell reference>”).Borders.Weight = <thickness style>
Range(“<cell reference>”).Borders.Color= <rgb color>

Line style options: xlContinuous, xlDot, xlDashDotDot, xlDash, xlSlantDashDot, xlDouble
Thickness options: xlThin, xlMedium, xlThick

‘examples
Range(“B4”).Borders.LineStyle= xlDash
Range(“B4”).Borders.Color= rgbBlueViolet

What is the syntax to special paste something?

Range(“<your range>”).Copy
Range(“<cell of paste location>”).PasteSpecial Paste:=<xlPasteValues, xlPasteFormats, or xlPasteFormulas>

‘examples
Worksheets (“Sheet2”).Range(“A2:B2”).Copy
Range(“C3:D3”).PasteSpecial Paste:=xlPasteValues ‘copies values of range A2:B2 from another worksheet

What is the syntax to use radio button values?

<radio button name>.Value = <true or false>

‘example
If radioVegetarian.Value = true Then
    MsgBox(“Your dinner will be a salad”)
End If