This is a video I posted on YouTube on conditional formatting. It is not of a perfect quality given the restrictions we are imposed by YouTube (hopefully things will improve).

I hope you enjoy it. Any comments can be left here or in the YouTube page.

NOTE: Macros must be enabled in order for this solution to work.

A lot of people need to list, in a worksheet, files located in a Windows folder! Now, the trouble starts when people decide to use VBA for that. Although this is okay, not everyone is fluent in VBA to write such code.

However, there is a simpler trick to that. By using Excel 4.0 macros you can accomplish that very easily. In this video, I show you how to get that done.

Here's a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here's the solution! Here's a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here's the solution!


NB: This is an adaptation of a trick found on the book "This Isn't Excel, It's Magic" by fellow Excel MVP Bob Umlas. The book can be found and bought at/from http://www.amazon.com/This-Isnt-Excel-Its-Magic/dp/0970827652/ref=sr_1_1?ie=UTF8&s=books&qid=1234097616&sr=8-1