+ Reply to Thread
Results 1 to 11 of 11

Cataloging of the tools

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Cataloging of the tools

    Hi

    We learn some new code, a new technique to do something in VBA, we learn a new method from someone and all these are our tools. But they are toooooo many.

    I have also too many but when I need it I spend much time to find them.

    "How to organize our arsenal so that the right weapon at the right time could be pulled out?"

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Cataloging of the tools

    I keep a word document with formulas and code snippets -- 422 pages and counting.
    Entia non sunt multiplicanda sine necessitate

  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
    6,986

    Re: Cataloging of the tools

    .
    I use a Master Folder with many other folders all titled by "tool type" : i.e., Menus ; Forms ; Formulas ; Rows/Columns ; Database ... etc., etc.

    Each of the projects or Word Docs in those folders has a descriptive title to narrow it down further.


    However, I am finding the same issue as you .... although things are cataloged it is becoming more a task of locating what I want.

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

    Re: Cataloging of the tools

    Maybe SnippetManager?
    - freeware
    - 37 languages supported
    - no setup required

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

    Re: Cataloging of the tools

    .
    Great recommendation.

    Here is a link to more ... don't overlook additional links found in the COMMENTS section of this URL.

    https://speckyboy.com/desktop-applic...code-snippets/

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Cataloging of the tools

    I have a 3 notepads.

    But my most useful techniques I post on my blog site, I have to admit I search my own site frequently...
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Cataloging of the tools

    I keep a Workbook (2.36mb) with all the code I've written as well as routines I've copied
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

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

    Re: Cataloging of the tools

    .
    xladept:

    How do you search for what you need in the workbook ?

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Cataloging of the tools

    In the VBE, Control F with a keyword, say I have code by Jindon - I search Jindon or say I can't remember the finder code for the last column or row - I search Previous and like that

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

    Re: Cataloging of the tools

    .
    Neat idea.

  11. #11
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Cataloging of the tools

    Hi Imran Bhatti

    I do something similar...
    VBA Code Pic.jpg
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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. [SOLVED] VBA: Tools -> Reference
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2017, 04:55 AM
  2. [SOLVED] "IF" Formula Needed for 2 sheet cataloging
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2016, 08:43 PM
  3. Looking for new tools!
    By brkyng in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-06-2013, 01:45 AM
  4. Tools > References
    By jimmy554 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2011, 05:48 AM
  5. Tools Menu Bar
    By daryl38 in forum Excel General
    Replies: 2
    Last Post: 01-07-2008, 04:12 AM
  6. Form Tools not available
    By davistax in forum Excel General
    Replies: 2
    Last Post: 04-08-2007, 08:02 PM
  7. [SOLVED] Tools | References
    By AA2e72E in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2006, 05:35 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