Command Buttons, Macro's, and Cell References!

dai_hop

New Member
Joined
Oct 11, 2004
Messages
20
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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Glaswegian

Well-known Member
Joined
Oct 14, 2003
Messages
1,487
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,421
Messages
5,596,033
Members
414,039
Latest member
southike

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top