Hi all. I can't seem to figure out how to initiate crosstalk between VBA code in a specific Worksheet and VBA code within a particular module. Let me try to explain...I have a scrollbar, and for each value the contents of a particular cell are highlighted. I'd like to also activate hyperlinks for each of the highlighted cells. When the user clicks the hyperlinked cells, I'd like the scrollbar to jump to the corresponding value.
I've got VBA code that will run when a hyperlink is clicked, and I've got the scrollbar VBA code working properly, but I can't figure out how to call the scrollbar code from the hyperlink code. Does that make sense?
Any ideas?
Thanks,
JBro
I've got VBA code that will run when a hyperlink is clicked, and I've got the scrollbar VBA code working properly, but I can't figure out how to call the scrollbar code from the hyperlink code. Does that make sense?
Any ideas?
Thanks,
JBro