VBA Save cell value in a variable

Save the cell value in a variable to re-use it later in your macro.

Code:

Sub save_cell_value_in_variable()

'how to read/save the value of a cell in a variable

Dim ws_sheet As Worksheet
Dim cell_value As Variant

'identify the worksheet
Set ws_sheet = Worksheets(1)

'find the cell value from the range name , A1 in this example
cell_value = ws_sheet.Range("A1").Value

'display the value in a message box
MsgBox ("Test 1 : " & cell_value)

'find the cell value with Row/Column properties, row 1 and column 1 in this example (which is also A1)
cell_value = ws_sheet.Cells(2, 1).Value

'display the value in a message box
MsgBox ("Test 2 : " & cell_value)

'find the cell value with Row/Column properties and column name, here, row 1 and column A
cell_value = ws_sheet.Cells(1, "B").Value

'display the value in a message box
MsgBox ("Test 3 : " & cell_value)

End Sub

-------------------------------
THANK YOU
-------------------------------
For watching my videos,
Your shares
And your comments!

-------------------------------
CONTACT ME
-------------------------------
Send your messages (questions, training requests or creation of files): https://www.kevinbrundu.com/contact/
Stay informed: https://kevinbrundu.com/en/homepage

-------------------------------
ONLINE COURSES
-------------------------------
Find all the news and links of my online courses on my website https://kevinbrundu.com/en/homepage

-------------------------------
SOCIAL NETWORKS
-------------------------------
Website: https://kevinbrundu.com/en/homepage
LinkedIn: https://www.linkedin.com/in/k%C3%A9vin-brundu-9a910241/
Facebook: https://www.facebook.com/KevinBrunduAuteur/