VBA 123

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

Sorted from new to old.

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Thu 3PM

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

CutString12

Cuts string between two numbers that found inside string. Like extract the ...

Aug22

IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Aug21

Choose2

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

Aug20

HTMLdd_Fromdt

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

Aug19

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

Aug15

ANmaRead_1stFile

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

Aug11

HTMLTable_FullRow_NonBlanks

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

Aug7

ExtractNumeric_FromCell

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

Aug6

HTMLTable_Cell

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

Aug5

HTMLRow_Cell

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

Aug4

CutString96_NumberX

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

Aug2

CountNumbers_inString

Returns how many numbers found inside a text

Aug1

ANmaSearch_SpaceFriends and LeftSpaceFriends

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

Jul30

1 2 ...7 8