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" <dstiefe@discussions.microsoft.com> wrote in message
news:831AD9CC-3A68-44AE-BBA9-60EE078D6642@microsoft.com...
> 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" <dstiefe@discussions.microsoft.com> wrote in message
>> news:BFD6D9CC-A1CB-4A78-9119-F572F47FCF6A@microsoft.com...
>> |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
>>
>>
>>