VBA-Excel 369

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

Sorted from new to old.

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

Refreshing image

Refreshing image in ImageControl of VBE Userform When we change picture of ...

2020Feb3

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

1 2 ...16 ...23 24