I am trying to , through VBA, scrollbars that link to certain cells.

The problem is I do not know exactly where the scrollbar will be added. So
I am looping through the sheet for cells that contain "Total" when I find it
I want to add a scrollbar that "links" to the cell one column over. The only
way I have found the "Cell link" property to work for the scrollbar is if
it's hardcoated. For example, ".linkedcell = "$B$3".

How do i set the property for ".linkedcell" if I am uncertain about the cell
it will be linking to.

visual example...http://www.myanalystteam.com/linked.ppt
Thank you

Daniel

Once you found your cell use the Offset method in whatever direction gives
you "one column over" and then the Address property of that.

--
Jim
"dstiefe" wrote in message
...
|I am trying to , through VBA, scrollbars that link to certain cells.
|
| The problem is I do not know exactly where the scrollbar will be added.
So
| I am looping through the sheet for cells that contain "Total" when I find
it
| I want to add a scrollbar that "links" to the cell one column over. The
only
| way I have found the "Cell link" property to work for the scrollbar is if
| it's hardcoated. For example, ".linkedcell = "$B$3".
|
| How do i set the property for ".linkedcell" if I am uncertain about the
cell
| it will be linking to.
|
| visual example...http://www.myanalystteam.com/linked.ppt
| Thank you
|
| Daniel

Thank you for responding...I guess I'm still confused as how I would use the
offset method in this situation.

would it look like this:

..linkedcell = "object.cells(i,3).offset(1,0)"

"Jim Rech" wrote:

Once you found your cell use the Offset method in whatever direction gives
you "one column over" and then the Address property of that.

--
Jim
"dstiefe" wrote in message
...
|I am trying to , through VBA, scrollbars that link to certain cells.
|
| The problem is I do not know exactly where the scrollbar will be added.
So
| I am looping through the sheet for cells that contain "Total" when I find
it
| I want to add a scrollbar that "links" to the cell one column over. The
only
| way I have found the "Cell link" property to work for the scrollbar is if
| it's hardcoated. For example, ".linkedcell = "$B$3".
|
| How do i set the property for ".linkedcell" if I am uncertain about the
cell
| it will be linking to.
|
| visual example...http://www.myanalystteam.com/linked.ppt
| Thank you
|
| Daniel

I'm not really to sure what you're doing. If you know the name of an object
you can find the cell it starts in and then any cell in relation to that
cell. So if you wanted it put some text in the cell to the right of a
button you could do this:

Activesheet.Buttons("Button1").TopLeftCell.Offset( 0,1).Value = "abc"

I hope this is getting closer to what you want to do...

--
Jim
"dstiefe" wrote in message
...
Thank you for responding...I guess I'm still confused as how I would use
the
offset method in this situation.

would it look like this:

.linkedcell = "object.cells(i,3).offset(1,0)"

"Jim Rech" wrote:

Once you found your cell use the Offset method in whatever direction
gives
you "one column over" and then the Address property of that.

--
Jim
"dstiefe" wrote in message
...
|I am trying to , through VBA, scrollbars that link to certain cells.
|
| The problem is I do not know exactly where the scrollbar will be added.
So
| I am looping through the sheet for cells that contain "Total" when I
find
it
| I want to add a scrollbar that "links" to the cell one column over.
The
only
| way I have found the "Cell link" property to work for the scrollbar is
if
| it's hardcoated. For example, ".linkedcell = "$B$3".
|
| How do i set the property for ".linkedcell" if I am uncertain about the
cell
| it will be linking to.
|
| visual example...http://www.myanalystteam.com/linked.ppt
| Thank you
|
| Daniel