Keeping Track of VBA

[Jim Clayton]

So many questions, so many projects...so many macros. Does anyone have a good solution for maintaining some sort of VBA filing system for all the code from past projects that might prove useful in the future? A toolbox of sorts.

[Logit]

.
Some folks have put together small projects that do exactly what you are seeking. (Database)

Others have looked on the Internet for freebie stuff already compiled into free standing programs. (Database)

Some have created a simple database using an Excel spreadsheet.


I was seeking the same thing about a year ago because my "toolbox" was getting full to over flowing with code I knew would be useful in the future. I received basically
the answers listed above.

After awhile it became clearer that maintaining a snippet of code concerning a specific process was the required approach. Like an example of an ARRAY - utilizing an ARRAY in a project,
using IFERROR in a formula, a section for just TIME and Timer projects, how to write data from a USERFORM with textboxes to a worksheet, and other things.

I have also learned that so long as the Internet is up and running, I will find the majority of my assistance from Google or another search engine. When it gets down to finalizing parts
of code to accomplish my goal ... I turn to the Experts here to assist.

Here are a few resource links :

https://support.office.com/en-us/art...1-ae005a9bc790

https://www.wizdoh.com/how-to-store-...or-future-use/

[shg]

I have a VBA folder with .bas folders each containing one to a dozen or so short related routines that I struggle to give meaningful file names, e.g.,

chtSetSquareAxes.bas
combinBinomMass.bas
combinChineseMenu.bas
combinCombinAndPermut.bas
combinComboSeq.bas
combinDeBruijn.bas
combinLexOrderCombos.bas
combinLexOrderPerms.bas
combinMultichoose.bas
combinNestedForLoops.bas
combinPermuteString.bas
combinRandomWalk.bas
cryptoVigenere.bas
dateDateDif.bas
dateNthDay.bas
fileExportToTabFile.bas
fileExportToTextFile.bas
fileFile2Str.bas
fileIsFileOpen.bas
fileListFiles.bas
fileMakeDirTree.bas
fileMergePDFs.bas
fileOpenWkbWritable.bas
filePlaySound.bas
fileUseFileSystemObject.bas
financeAllocateByMonth.bas
mathBaseConversion.bas
mathBetaPolynomial.bas
mathBijectiveNumeration.bas
mathBinarySearch.bas
mathCircumcenter.bas
mathCircumcenter2D.bas
mathCombinationSums.bas
mathContinuedFractions.bas
mathConvolve.bas
mathCRC32.bas
mathCubicSpline.bas
mathDblHomo.bas
mathDMS2Deg.bas
mathDrawDown.bas
mathDyck.bas
mathERF.bas
mathExpPricing.bas
mathFibonacci.bas
mathFisherExact.bas
mathFloatingPoint2Byte.bas
mathFreeformArea.bas
mathGcdLcm.bas
mathGeneratingFunctions.bas
mathHullsMovingAverage.bas
mathImagePlaneFuncs.bas
mathIntersectLine.bas
mathIntIndexMatch.bas
mathIrwinHall.bas
mathJosephus.bas
mathKadane.bas
mathKappa.bas
mathKendallTau.bas
mathLineGeneralization.bas
mathLiteralArray.bas
mathLuhn.bas
mathMarginDiscountPrice.bas
mathMatrices.bas
mathModularInverse2.bas
mathMoonAge.bas
mathMortonCode.bas
mathNumSpares.bas
mathParabola.bas
mathPartitions.bas
mathPartitionsFixedLen.bas
mathPoissonFuncs.bas
mathProbabilityOfRun.bas
mathQuaternions.bas
mathRand.bas
mathRandSeed.bas
mathRandStringCutting.bas
mathResistorValues.bas
mathSignDigitRnd.bas
mathSimpsonIntBetaDist.bas
mathSimpsonIntegrator.bas
mathStDev.bas
mathStringArithmetic.bas
mathStrings.bas
mathTrig.bas
mathVec2.bas
mathVectorLib.bas
mathWeightedCorrelation.bas
mathWeightedMedian.bas
mathWgtMedWIP.bas
pdfMergePDFs.bas
sortIndex.bas
sortInsertion.bas
sortQuickSort.bas
sortStringSorts.bas
strCatenate.bas
strDeDup.bas
strEditDistance.bas
strFactorial.bas
strInFix.bas
strISBN.bas
strJaccardIndex.bas
strJoin.bas
strKindaLike.bas
strLenLeftMidRight.bas
strLongComSubstring.bas
strNumberCDRLs.bas
strPadNumbers.bas
strPermut.bas
strRemoveAccents.bas
strShowBinary.bas
strSpellCheck.bas
strSpellDollars.bas
strSplitText.bas
strStr2Asc.bas
strStr2Lng.bas
strTranspositions.bas
strUnScientific.bas
strWBS.bas
strWordPattern.bas
sysFileSearch - Mehta.bas
sysGetDriveSerialNumber.bas
sysMeasureWindowSize.bas
sysPath2UNC.bas
sysPing.bas
sysSafeArrayInfo.bas
uiProgressMeter.bas
vecPlaneAlgebra.bas
xlFormulaTimer.bas
xlGetMonospacedFonts.bas
xlHiddenNames - Pearson.bas
xlInterpInSitu.bas
xlInterpolators.bas
xlMake1D.bas
xlMakeDynRanges.bas
xlMakeRelNames.bas
xlMergeStyles.bas
xlPackCells.bas
xlRangeColorIndex.bas
xlRangeSetAlgebra.bas
xlSetMacroOptions.bas
xlSheetMap.bas
xlSquareCells.bas
xlSum3D.bas

It works pretty well for me.

[Logit]

shg

Thank you again for your help yesterday !

[Logit]

.
Here is a small project that might be of use for this purpose ...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim sPath As String
    Dim sDefaultPath As String
    Dim fd As FileDialog
     'Submittal Package Link
    Dim R As Range
    Dim cell As Range
     
    Set R = Intersect(Target, Range("A:A"))
     
    If Not R Is Nothing Then
        For Each cell In R
            If MsgBox("Do you wish to link to the submittal package?", vbQuestion + vbYesNo, "Link to File?") = vbNo Then
          
                Exit Sub
            End If
            Set fd = Application.FileDialog(msoFileDialogFilePicker)
            sDefaultPath = "C:\Users\My\"
            With fd
                .AllowMultiSelect = False
                .InitialFileName = sDefaultPath
                .Title = "Select File to Link to"
                .ButtonName = "Select File"
                If .Show = True Then
                    sPath = .SelectedItems(1)
                Else
                    Target.Hyperlinks.Delete
                    Exit Sub
                End If
            End With
            ActiveSheet.Hyperlinks.Add Anchor:=Target, Address:=sPath
            
            MsgBox "Link successfully created to " & sPath, vbInformation, "Link Created"
        Next cell
    End If
     
End Sub

You could use one worksheet for each type of code. Sheet1 could be named LISTBOX, and all the created links on that sheet would detail listbox code. Another sheet might be named
PRINT METHODS and all the links there pertain to printing.

There is other code that could be used to create a MASTER MENU at the very beginning that will list the names of the worksheets and create hyperlinks to each sheet.

[Jim Clayton]

VBA to keep track of VBA; only in Excel Help Forum...