VBA 126

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel
  2. Languages
  3. VBA
Sorted from new to old.
Card image
ConvertImage_IrfanView

Converts an image from any image into any image using IrfanView command line ...

2019Jun26
Card image
Inputbox vs Application.Inputbox

fm20.dll has another inputbox to be used It is smaller, maybe more straight ...

2019Apr14
Card image
MouseDown and MouseUp in FM20 controls

MouseDown and MouseUp in VBA (fm20 controls) are different from those in VB6 ...

2019Apr14
Card image
CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

2019Jan5
Card image
ChrW

Insert special characters inside Cell, using ChrW

2018Sep19
Card image
PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8
Card image
Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29
Card image
Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29
Card image
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26
Card image
GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19
Card image
MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

2018Jul11
Card image
CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11
Card image
RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

2018Jul9
Card image
CreateFullTree

Creates full tree if not found

2018Jul9
Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7
Card image
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6
12...5...78