Search results 162

Sorted from new to old.

RGB2HTML + HTML2RGB

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

2018Jul9

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

[TAB] inside textarea

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

2018Jul6

FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

2018Jul5

SwapDate

Changes date format from US to International or from international to US. ...

2018Jul5

XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

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

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

CellSave (SimpleSave)

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

2018Jun26

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

1 2 ...9 10 11