+ Reply to Thread
Results 1 to 9 of 9

VBA interface

  1. #1
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    VBA interface

    Hi all,

    This might be an odd question and equally impossible.

    I have an entire list of modules running in my vba interface. Is it at all possible to add extra folders just to have a bit more organised look in my vba?
    Last edited by Jacques Grobler; 06-14-2011 at 04:38 AM.
    Jacques


  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: VBA interface

    are the modules all in one workbook?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    Re: VBA interface

    Hi Roy,

    They are all in an addin.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,657

    Re: VBA interface

    I don't believe you can add further folders beyond the Excel Objects, Forms, Modules and class ones.

    How many module objects do you have?
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    Re: VBA interface

    Currently in the order of 12, but I'm still busy with my developement and believe that this will increase as time goes by.

    If I cannot add folders, is there a way to better manage my modules/code for navigation? I'm still a bit new to programming and dont programme everyday, so I'm not to aware of GOOD or effective programming practices...

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,657

    Re: VBA interface

    I guess the first question is why 12 modules? You do not have to have a separate module for each macro.

  7. #7
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    Re: VBA interface

    It is because I have each module containing equations or procedures pertaining to different aspects.

    All general maths in one, company specific maths in the next, etc etc etc...

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,657

    Re: VBA interface

    so it sounds as if you have your code as organised as it can be.

  9. #9
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    Re: VBA interface

    Just thought as there are some brighter minds and better trained minds than mine, I might get some good tips...

    Thanks anyway

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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