Browse codes

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

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

Fri Mar20 7AM

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

Mon Mar9 6PM

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

Sat Feb22 8PM

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

Sun Feb16 7PM

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

Sun Feb16 10AM

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

Wed Feb5 8PM

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

Mon Feb3 6PM

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

Fri Jan3 5PM

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

Fri Jan3 4PM

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

2019Oct3

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

2019Aug1

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12