To get numerical data from the worksheet into your VB code use functions Range or Cells. For example, to get the value of cell "B2" into variable a in your VB code use:

a = Range("B2").Value

Alternatively, you could use

a = Cells(2,2).Value

to load your data value.