Search results 133

Sorted from new to old.

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

Send To folder

Where can I find the SendTo folder? I always wanted to modify that list and ...

2019May15

Windows XP as website

Having a website that looks like Windows XP is great out-of-the-box idea Here ...

2019Jan17

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Shortcuts (rundll32.exe)

Shortcuts to do certain commands in Windows (tested in Windows 7) Shutdown, ...

2019Jan1

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

Application_OnStart

How to use Global.asa

2018Sep5

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

CutString_Words_Left + CutString_Words_Mid

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

2018Aug8

Textbox focus issue fix

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

2018Jul29

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

ANmAjax

Trying to simplifying applying AJAX in my websites and tools, this is the ...

2018Jul23

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

1 2 ...7 8 9