Search results 375

Sorted from new to old.

RangeTakePicture_Linked

Converts a range in Exce lsheet into picture. linked or unlinked. Important ! ...

Sep30

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

Jul17

UnicodeToChrW

Converts a unicode number into its ChrW text. It automatically uses surrogate ...

Jul17

Site as app (PWA)

Instructions on how to convert a website into an app, called Progressive Web ...

Jun19

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

Apr30

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

Mar24

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Mar11

1 2 ...23 24