ActiveX Format Control - multiple cell link?

[Newport Count]

Hi there,

I have an ActiveX control in a worksheet that acts as a scroll bar which enables users to click through different month's worth of data in a dashboard.

I just wanted to know if it is possible to have more than one cell in the 'Cell link' field, ideally a cell in a different tab. I've tried to enter this in a few different formats but just get a formula error each time.

For info, the cell it links to is a number which then provides the figure for a look up in a field next to the scroll bar that displays the month name.


Cheers,
Rich

 

[Newport Count]

I don't think it is possible to have more than one cell linked in the control itself but my workaround on this (which hopefully may help someone else) was to reference the same cell but using two different scroll bars on each tab in the spreadsheet. Each time a scrollbar is clicked, the other tab also updates at the same time, therefore enabling two different dashboards to be displayed with the same month on two different tabs.

PS - i havent been working on this sine last November lol


Cheers,
Rich

 

[hotabae]

Well maybe your situation doesn't allow for this, but have you tried something like this:

If the Control's Cell Link is A1 on Sheet 1, Place - "=Sheet1!A1" into a cell on Sheet 2.

There are some fairly obvious limitations with this method, but maybe it will work for you?

 

[Newport Count]

Thanks for responding - I did try that initially but then this was overriden by clicking the scroll bar on that tab, which then didn't update the other tab! So they were acting independently of each other.

 

[hotabae]

Oh, I didn't read the dates on the post. For some reason I thought you had just asked how to solve it.... My B


Edit: I only just realized that you answered your own question (oops)

 

[Newport Count]

Yeah that is exactly what i did to make it work