Search results 263

Sorted from new to old.

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

CutString_Words_Left + CutString_Words_Mid

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

Prn

Printout into page, along with additional function to decide where to put the ...

2018Aug5

Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

2018Jul31

Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29

DegreeC2K

Convert a Celsius temperature to a Kelvin temperature. To convert Fahrenheit ...

2018Jul25

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

ImageRotate_IrfanView

Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...

2018Jul22

CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

2018Jul22

CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...

2018Jul14

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...

2018Jul14

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

1 2 ...14 ...16 17