Search results 61

Sorted from new to old.

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

PhotoViewer dll

Open image using legacy PhotoViewer from Windows 7 Command line call to use ...

2021Aug25

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

Paste into textbox

Paste text from clipboard into textbox

2020Oct11

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

Refresh HTML page + Go Back

HTML Javascripts to refresh page And another line to go back to previous page. ...

2020Sep7

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

2020Jul22

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

2019Dec5

Parts-File2Page

A classic ASP include file to read txt file of list into a page using bootstrap ...

2019Oct6

1 2 3 4