Search results 60

Sorted from new to old.

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

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

2018Aug9

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

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

2018Jul9

Showing thumbnails inside sheet and enlarging each when click

2018Jul9

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

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

2018Jun7

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

Shows an image after clicking on its thumbnail, like in web applications Can ...

2018May20