Search results 179

Sorted from new to old.

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

RunOnTime

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

2022Sep29

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

AddDatabar_ConditionalFormatting

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

2022Aug22

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

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

RowList_Matching

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

2021Dec27

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

1 2 ...5 ...11 12