View Single Post
  #1   Report Post  
luke
 
Posts: n/a
Default Wherre best to place code


I have an excel workbook that uses active -x controls. It allows the
user to model the performance of a micro-scale wind turbine (small
device that fits onto a rooftop). I have VBA code that is located for
each worksheet, some that is contained in Forms and other code that is
located in modules.

My question is: in terms of keeping the workbook small and running
quickly is it Ok to have code for each worksheet or place it in
modules?


thanks, luke


--
luke
------------------------------------------------------------------------
luke's Profile: http://www.excelforum.com/member.php...o&userid=21401
View this thread: http://www.excelforum.com/showthread...hreadid=397790