VBA-Excel 329

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

Sorted from new to old.

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...

2018Jul14

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

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

1 2 ...17 ...20 21