Search results 89

Sorted from new to old.

Too large procedures

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

2022Jan29

OpenAnyFile

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

2022Jan28

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

PhotoViewer dll

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

2021Aug25

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Paste into textbox

Paste text from clipboard into textbox Needs Userform, textbox, commandbutton

2020Oct11

WinImage.dll

An old DLL library enables reading and writing to floppy disks (and/or images) ...

2020Jul18

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Evaluate

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

2020Feb16

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22

ANBSCaptchaBox (Part 4)

Attempt to create Captcha inputbox as simple as possible using third party ...

2019Dec7

Text Shadow CSS3 Generator

Online tool to create css3 text shadow, free. Technically, generate the CSS3 ...

2019Oct23

img-2 lazy loading

A library to delay load images as needed From

2019Jul12

1 2 3 ...5 6