Search results 59

Sorted from new to old.

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

MouseDown and MouseUp in FM20 controls

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

2019Apr14

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

CTRL+K,C

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

2019Jan5

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

2019Jan1

ConfigWeb_Read

Reads a key value from certain section in Web.config Originally from ...

2018Sep5

INITool

INITool Object allows an ASP programmer to work with INI files on the server. ...

2018Aug25

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

2018Jul25

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

2018Jul6

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

1 2 3 4