+ Reply to Thread
Results 1 to 4 of 4

What Does Your VBA / Excel Toolbox Look Like ?

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    What Does Your VBA / Excel Toolbox Look Like ?

    I find my VBA / Excel Toolbox becoming unmanageable. As time progresses the toolbox size has
    grown with so many 'much needed snippets' it is becoming increasingly more difficult
    to later locate those 'pearls of wisdom'.

    Presently my toolbox is a desktop placed folder (convenient access) with subfolders
    representing various coding topics: Forms, Sheet Functions, Formulas, ComboBox, etc.
    Each folder has alot of examples pertaining to the Folder Topic.

    Is there a better method of storing these snippets for future reference ?

    What do you use ?

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: What Does Your VBA / Excel Toolbox Look Like ?

    I use Access. I have columns for the name, brief description, topic/subtopic, link to the website I got it from (if applicable), and I attach excel sheets and .txt documents with the code. It's good because I can sort and filter. It works well for me. But then, my toolbox is (as of now) very small, so I have yet to find out if this is a good system.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: What Does Your VBA / Excel Toolbox Look Like ?

    Raphaelp

    Sounds like a winner !



    Let me add one other request ..

    If respondents do not mind, would you be willing to post a sample of your method (workbook, Access, other software, etc.) ?

    This could be invaluable for others (as well as myself).

    Thank you so much !

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: What Does Your VBA / Excel Toolbox Look Like ?

    Does anyone else have a unique method of storing your code in a 'toolbox' ?

+ 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. Toolbox Has No Additional Controls - Excel
    By sayed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 01:35 AM
  2. Excel Control Toolbox
    By Kr4ftw3rk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2008, 07:54 PM
  3. toolbox controls in excel are invisble ?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  4. toolbox controls in excel are invisble ?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] toolbox controls in excel are invisble ?
    By Dave in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] toolbox controls in excel are invisble ?
    By Dave in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] toolbox controls in excel are invisble ?
    By Dave in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2005, 05:05 PM
  8. Controls Toolbox control vs Form Toolbox control
    By Tony_VBACoder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2005, 05:06 AM

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