VBA-Excel 370

Visual basic for applications that works only in Microsoft Excel, aka macros

Sorted from new to old.

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za.exe (found in attached zip) ...

2018Jul14

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

2018Jul9

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4

1 2 ...20 ...23 24