roll onoff buttons

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Roll on/off buttons

Roll on/off buttons

resolvedResolved · Medium Priority · Version 2003

Davinder has attended:
Excel VBA Intro Intermediate course

Roll on/off buttons

Is it possible to create buttons on a form and make them change colour when you hover the mouse over the button to give a form a more professional look and feel?

I presume you will need two images of the same button so you can determine what the button looks like when the mouse is over and not over the button but what code would you need to use in order to obtain this effect?

RE: Roll on/off buttons

Hi Davinder, thanks for your query. It's more complicated than you might think! The use of two images to create a rollover is a web browser feature and to create the same effect on a VB form takes some coding. Have a look at this thread:

http://www.ozgrid.com/forum/showthread.php?t=62478& ;page=1

If you want to soup up the look of the forms, have a look on the net for some free bespoke form controls, usually saved as OCX files. When you install these they become available in your controls toolbox and and you can use them on your form in the usual way, but they can be much more visually interesting than the standard grey controls.

Hope this helps,

Anthony

Thu 30 Sep 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips


Server loaded in 0.07 secs.