Pass ActiveCell Value to my Add In Workbook
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
On Sep 3, 3:34*am, RyanH wrote:
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!
--
Cheers,
Ryan
|