Search results 155

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

Jul27

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Jun30

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

Jun12

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

May27

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

ListBox_Read and ListBox_Save

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

Mar11

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

1 2 ...9 10