Excel

Can Do

XTreme Excel

Please check back soon. This page will be under continual construction :-)

These pages will be dedicated to things you thought (or didn't know) that you CAN DO in Excel !

Coming soon...........

1) Changing the Name Box list width

2) Changing the colour of the Tab (A hack :-) )

3) Display a Screen Saver in Excel

4) Phoning from Excel

5) Animation

6) Userform tricks;

AMENDMENT - WILL ROLL THIS OUT IN ONE ROUTINE THAT COVERS THIS AND MORE

THE ROUTINE PROJECT = INTERNET SEARCHING

a) Min/Max, b) Keep on Top, c) Changing the UserForm shape

d) Animation, e) Captionless forms, f) Moving captionless forms

g) Disable moving of forms

h) XL97 (a Hack :-) ) making Userform modeless

i) Adding drop menus to forms

j) Adding a Clock (Timer)

h) Flashing Userform caption (by Colo)

i) Splash Screens: Via userforms incorporating, Transparency - fading in and out, handling of

Disabling Macros.

7) Opening ANY program

8) Excel to Download Files from the internet

9) Opening Chm files (Microsoft compiled help files)

10) Message boxes - timed msgboxs

11) Opening Control Panel Applications

12) FTP within excel (For Colo)

13) Virus test - Test your Anti-Virus software

14) Browse Folders (Various methods)

15) Get File discriptions

16) Highlighting the active cell location

And @ MicroSoft

17) Playing AVI, Midi, Wav, and more files

18) Running VBA code from a dropdown list selection

19) Recording & PlayingBack a Wave file

20) RSS - See how to use RSS from within XL

21) Xtreme games (you have to see these to beleive it!)

22) Password character for InputBox 2 methods.

23) Zipping workbooks and emailing them from within Excel

24) Speech in Excel (Get your Spreadsheet to Talk you don't need Excel XP)

25) Saving a range selection as an image

26) Custom MsgBox - customize a msgbox using API's

27) Getting Class names and Windows handles

28) Getting a list of your ShortCut keys

29) Painting in Excel - convert an image file pixil by pixel to Excel cells! A must VIEW!

Ivan F Moala

Visits here

This page was last updated on: March 22, 2009

Greatest place to be

Thanks for visiting my site lucky visitor: