View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aspadda[_2_] aspadda[_2_] is offline
external usenet poster
 
Posts: 2
Default 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...