Yes this is possible.
Here are some code examples that will assist in the inspection of cell values:
theCellValue = ThisWorkbook.Worksheets(WS).Range("A4").value
Then, if the value is being stored in the cell, you would loop by the variable, as in:
for theloop = 1 to theCellValue
MsgBox("The Counter is on " & theloop & " of " & theCellValue)
There you have it!