Search results 60

Sorted from new to old.

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

Oct11

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Sep30

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

May11

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

Apr30

SettingRead_Bulk

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

2024Nov3

ANmaFiles2List

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

2024Sep21

ANmAdd_ThenSort_2Columns

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

2024Jun1

ANStrFind_AndOrAdd

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

2023Dec19

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

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

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

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

1 2 3 4