Search results 155

Sorted from new to old.

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

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2

RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2

1 2 ...9 10