Excel

Userforms:

Changing Shapes

Keep Form on TOP

Making form Transparent

Searching the internet

NotePad Utilty

Originally I was going to do seperate pages on each of the following (See above) but thought it would be better if I rolled everything into one project and showed you how to do these through the project.

If you want basic how to's then look here Excel/VBA userforms 101 and FAQ

My thanks to;

herilane @ http://www.visualbasicforum.com

Senior Contributor

Forum Leader

* Expert *

From: London, England

Also here Part1

So in keeping with the X Factor I chose 2 projects to do this with;

1) A Search form - Form that searchs the boards such as MrExcel, Microsoft News groups, Google and more. (see screen shot below)

2) A NotePad form - Incorporated in the Search form is a notepad utility, BUT this one shows a little more detail and also how to use the inbuilt Commandbars for Userforms.

(See below screens)

Please NOTE: Projects still testing and NOT finished....................

In the mean time download this Example...........