+ Reply to Thread
Results 1 to 3 of 3

Storing code in Excel Objects vs. Storing code in Modules

  1. #1
    Registered User
    Join Date
    09-14-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    82

    Storing code in Excel Objects vs. Storing code in Modules

    Hi,
    Is anyone able to explain the difference or impact between storing code in an Excel Object (i.e. an excel sheet) versus storing it in a separate module? Which one is generally recommended as best practice?

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Storing code in Excel Objects vs. Storing code in Modules

    Read here: Excel Object vs Module
    Hope it will help

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Storing code in Excel Objects vs. Storing code in Modules

    .
    .
    If the problem is solved it's always a good practice to show respect to the person(s) who have helped you is a click on the Add Reputation first and then mark the thread as SOLVED, Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-09-2014, 08:29 AM
  2. Organizing and Storing Code/Formulas
    By k64 in forum The Water Cooler
    Replies: 19
    Last Post: 06-24-2014, 10:24 AM
  3. Storing VB Code in a variable withing a Macro
    By reclmaples in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-02-2009, 11:45 AM
  4. Storing and using objects in variables.
    By h20skee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2008, 06:36 PM
  5. Module vs. UserForm - where should I be storing my code?
    By js999 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2007, 02:26 PM
  6. storing a value in code
    By Giselle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2006, 06:35 AM
  7. [SOLVED] storing of VBA code
    By kurt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2006, 02:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1