roll onoff buttons
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Wed 22 Sep 2010, 20:11Delegate Davinder said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Fri 24 Sep 2010, 10:15Trainer Anthony said...

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.

 

Please browse our web site to find out more about
advanced excel class and other Microsoft training courses.

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard