Search results 61

Sorted from new to old.

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

ImageMSO list

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

2025Apr30

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

2025Mar24

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

1 2 3 4