Search results 176

Sorted from new to old.

Excel user name

Get application user name or change it Originally from

2023Jun14

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

Excel recovered files

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

2023Mar31

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

Dropdown button commands

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

2022Oct12

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

1 2 3 ...10 11