vba variable = cell value code example
Example 1: vba set cell value
Range("A2").Value = 1
Cells(2,1).Value = 1
Range("A2:A5").Value = 1 ' all cells in the range
Example 2: vba declare variable with value
Dim myString As String: myString = "aaa bbb"
Dim myStringCaps As String: myStringCaps = UCase("aaa bbb")
Dim myPart As Variant: myPart = Split(myString)
Dim ws As Worksheet: Set ws = ThisWorkbook.Worksheets(1)
Const MY_CONST As String = "Value"