VBA 134

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

Sorted from new to old.

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

2024Aug19

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

2024Aug15

ANmaRead_1stFile

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

2024Aug11

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

2024Aug6

HTMLTable_Cell

Returns content of cell by location ... RowID and ColumnID HTMLTable expected ...

2024Aug5

HTMLRow_Cell

Returns column with ColumnID ... the full area between < td ...> and < /td> ...

2024Aug4

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

1 2 ...8 9