Relative Cell References within VBA code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2000 ActiveX Option Buttons from the Control Toolbar.
Within the OptionButton code, I am using a statement like:
Range ("B23") = OptionButton1.Caption
to place the Option Button caption text into a specific cell in my
worksheet. However if/when I insert or delete a Row or Column that relocates
cell B23 (in this example), the VBA code cell-address is not updated to the
new location. Is there a way to make the VBA cell reference relative so that
the VBA code does not have to be updated each time a design change
(Insert/Delete Row or Column) is made to the Worksheet?
Any help will certainly be appreciated.
Thank you
 
Bernie,
Thank you very much. So simple and it worked fine. I appretiate the time
you took to help.
Jandy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Sharing workbooks limitations - Merged Cells 12
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Absolute and Relative Cell References 1
Sum Worksheets 7
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
repost: How do I activate an option button? 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top