Search results 60

Sorted from new to old.

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Nov3

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Sep21

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

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

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

1 2 3 4