Form buttons with color

Praxis

Board Regular
Joined
May 8, 2002
Messages
70
Is there a way to assign different colors to a form button. I have (2) buttons on a form and I would like to make one green, and the other one red.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fryer Tuck

Board Regular
Joined
Mar 20, 2002
Messages
64
Yes.

First off, make them command buttons instead. (You will have to find these in the Control Toolbox). Then on the sheet or worksheet macro page, put the action to be taken when you click on it.

As for the coloring, go to the macro page and specify Draft Mode, then to the spreadsheet and highlight the button, then to the macro page and open the properties box and color to your hearts content.

F.T.
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
I would like to dedicate this post to Terry "MANHATTON" Hatton Res1cue New York

Remember rather that using the normal forms tool bar, which Jack say in Terry Hattons words is TOTALLY UN EXCEPTABLE, try any image, text box, JPG, whatever build your own in drawing toolbars

ITS fun and different and link the scripted code to that image.

I use alsorts of images and boxes and all forts, its such fun.

On a down sad note :cry: as late i have a JPG of Terry Hatton and many EMS crews from the World Trade Center desister.

Proves a point Terry Captin of Rescue 1 the link is in the lounge, was to days report.

Different a guys face in resuce gear!! but my work was second to him.

I have gifs of fire lines and so on i add as graphics, its RESPECT!!
 

Forum statistics

Threads
1,143,925
Messages
5,721,562
Members
422,372
Latest member
RoyRodger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top