Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging WorkBooks Not Working Gina Excel Discussion (Misc queries) 1 August 19th 08 11:30 PM
Working on Multiple Workbooks create_share Excel Discussion (Misc queries) 1 July 24th 06 12:25 PM
Working with Different workbooks eawinga Excel Discussion (Misc queries) 2 March 7th 05 02:06 PM
Working with Different workbooks eawinga Excel Discussion (Misc queries) 0 March 7th 05 09:59 AM
Working with Two WorkBooks Donald Lloyd Excel Programming 3 August 5th 03 05:20 PM


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"