I am STILL working on a spreadsheet that uses a lot of Option Buttons (all
grouped nicely). I am finding that the "Cell Link" sometimes gets
disassociated from the original cell. I would like to fix this by writing a
chunk of code for the ActiveSheet.OptionButtons. object, but don't know how
to tell it that OptionButton (Option Button 17) should be linked to cell
C$17$ (which has a named value of "LV_PAXType".

Can someone help?

Coincidence or is there a relationship between the option button name having
the row number in it.

Dim ob as OptionButton
for each ob in activesheet.Optionbuttons
sName = ob.Name
rw = trim(Right(sName,2))
ob.LinkedCell = "'" & Activesheet.Name & "'!C" & rw
Next

--
Regards,
Tom Ogilvy


"John Jost" wrote in message
...
I am STILL working on a spreadsheet that uses a lot of Option Buttons (all
grouped nicely). I am finding that the "Cell Link" sometimes gets
disassociated from the original cell. I would like to fix this by writing
a
chunk of code for the ActiveSheet.OptionButtons. object, but don't know
how
to tell it that OptionButton (Option Button 17) should be linked to cell
C$17$ (which has a named value of "LV_PAXType".

Can someone help?

Tom,
Thanks for your help. It was the "LinkedCell" object I was missing.
Unfortunately, the "$C" & rw won't help as my pointer may or may not be on
the same row in all instances. But this does get me where I need to go.

Where can I find all the Groupbox, OptionButton, and Checkbox
properties/object information? This has been a real stumbing block, as if I
dont know the property I need I dont know what to type.

"Tom Ogilvy" wrote:

Coincidence or is there a relationship between the option button name having
the row number in it.

Dim ob as OptionButton
for each ob in activesheet.Optionbuttons
sName = ob.Name
rw = trim(Right(sName,2))
ob.LinkedCell = "'" & Activesheet.Name & "'!C" & rw
Next

--
Regards,
Tom Ogilvy


"John Jost" wrote in message
...
I am STILL working on a spreadsheet that uses a lot of Option Buttons (all
grouped nicely). I am finding that the "Cell Link" sometimes gets
disassociated from the original cell. I would like to fix this by writing
a
chunk of code for the ActiveSheet.OptionButtons. object, but don't know
how
to tell it that OptionButton (Option Button 17) should be linked to cell
C$17$ (which has a named value of "LV_PAXType".

Can someone help?

In the object browser, right click and select view hidden properties. Then
find OptionButton in the object browser (under the Excel library).

--
Regards,
Tom Ogilvy

"John Jost" wrote in message
...
Tom,
Thanks for your help. It was the "LinkedCell" object I was missing.
Unfortunately, the "$C" & rw won't help as my pointer may or may not be on
the same row in all instances. But this does get me where I need to go.

Where can I find all the Groupbox, OptionButton, and Checkbox
properties/object information? This has been a real stumbing block, as if
I
dont know the property I need I dont know what to type.

"Tom Ogilvy" wrote:

Coincidence or is there a relationship between the option button name
having
the row number in it.

Dim ob as OptionButton
for each ob in activesheet.Optionbuttons
sName = ob.Name
rw = trim(Right(sName,2))
ob.LinkedCell = "'" & Activesheet.Name & "'!C" & rw
Next

--
Regards,
Tom Ogilvy


"John Jost" wrote in message
...
I am STILL working on a spreadsheet that uses a lot of Option Buttons
(all
grouped nicely). I am finding that the "Cell Link" sometimes gets
disassociated from the original cell. I would like to fix this by
writing
a
chunk of code for the ActiveSheet.OptionButtons. object, but don't
know
how
to tell it that OptionButton (Option Button 17) should be linked to
cell
C$17$ (which has a named value of "LV_PAXType".

Can someone help?