98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Roll on/off buttons
Roll on/off buttons
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recently used file listUnder 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. |