Pass ActiveCell Value to my Add In Workbook

[RyanH]

I have a worksheet double click event in Workbook("QUOTE.xls"). I also have
a Add-In Workbook("ADD IN.xla"). When I double click a cell in "QUOTE.xls" I
want to pass that Target.Value to a procedure in "ADD IN.xla". How do I do
this?

Thanks in Advance!

 

[paul.robinson]

Hi
If the AddIn is installed, then you do this in the normal way. If your
procedure is called Tester and Target.value is an integer (say) then
inside your double click event you put

Tester Target.Value

or
Dim TestValue as Integer
TestValue = Target.Value
Tester TestValue

where the code for Tester is of the form

Sub Tester (myValue as Integer)
'some code using myValue
End sub

The event code will find the sub Tester within the AddIn. If your
existing Tester code does not accept a parameter, then simply alter it
as above so that it does.

regards
Paul