Search results 67

Sorted from new to old.

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

IsNumericChar

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

Aug21

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Jul31

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Jul23

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

Jul2

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

2023Nov10

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

1 2 3 4 5