Command Buttons, Macro's, and Cell References!

[dai_hop]

Hello All,

I was wondering if anyone could tell me how I can reference the value of a particular cell value using VB?

I would like to use some Option Buttons to change the value of a particular cell, and then incorporate the value of that cell into some VB code, but how do I indentify that particular cell in VB?

Many Thanks

dai_hop

 

[Glaswegian]

You could assign the cell value to a variable

myVariable = Range("A1").Value

and then access that variable in your code. Depending on what you are doing you might have to be more explicit in referencing the worksheet

myVariable = Worksheets("Sheet1").Range("A1").Value

Is this what you mean?

Regards

 

[dai_hop]

Thats great! Thanks you very much!