VBA-Excel 353

Visual basic for applications that works only in Microsoft Excel, aka macros
  2. Languages
  3. VBA-Excel
Sorted from new to old.
Card image
FindFile

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

2018Jul11
Card image
ConvertMultiLine2 + 6

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

2018Jul11
Card image
Shapes-Macros

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

2018Jul9
Card image
WelcomeSheet

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

2018Jul9
Card image
FaceIDs

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

2018Jul9
Card image
XLThumbView

Showing thumbnails inside sheet and enlarging each when click

2018Jul9
Card image
Error_Raise

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

2018Jul7
Card image
LoadPicture_Safe

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

2018Jul7
Card image
FixENTERS_File

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

2018Jul7
Card image
Import_CSV

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

2018Jul7
Card image
FindVBAObject

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

2018Jul6
Card image
SortArea5

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

2018Jul5
Card image
SortArea3

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

2018Jul4
Card image
SortArea1

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

2018Jul4
Card image
Sort1Col

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

2018Jul4
Card image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30
12...19...2223