Search results 60

Sorted from new to old.

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

IsThere1_SPWB

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

2020Apr1

Refreshing image

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

2020Feb3

Shortcut website

Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...

2020Jan22

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

1 2 3 4