Working with two workbooks
I have a situation where I have almost 100 Plus templates (with couple
of
forms and data) and to all these templates i need to add one similar
form
with same data. What i am doing is creating an addin and calling the
form
from add-in.
I need to do something as mentioned below but don't know how?? (I want
to write this in Add In)
if addin.userform_addin.listbox1.value 20 then
Main_Template.userform_Main.listbox1.additem ("20")
else
Main_Template.userform_Main.listbox1.additem ("30")
end if
Can this be possible. and if so How? Writing this code in Add_in will
save
me rewriting of the same code in all templates.
Suggestions will be highly appreciated...
|