Search results 60

Sorted from new to old.

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

NextID_Reset

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

2020Mar31

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

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

2019Oct20

1 2 3 4