A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

changing the color of the buttons



 
 
Thread Tools Display Modes
  #1  
Old April 4th, 2005, 04:43 PM
Mr. V
external usenet poster
 
Posts: n/a
Default changing the color of the buttons

Hello Everybody!
Can someone tell me how to change the color of a button in a form. I am
making a form and the default color of the button is grey, is there any way
of changing that color?
Thx,
  #2  
Old April 4th, 2005, 04:57 PM
Bob Umlas
external usenet poster
 
Posts: n/a
Default

Click on the button, select a color from the pallette in the BackColor
property

Bob Umlas
Excel MVP

"Mr. V" Mr. wrote in message
...
Hello Everybody!
Can someone tell me how to change the color of a button in a form. I am
making a form and the default color of the button is grey, is there any

way
of changing that color?
Thx,



  #3  
Old April 5th, 2005, 05:25 AM
Mr. V
external usenet poster
 
Posts: n/a
Default

Thx for replying Bob, but I cant find the BackColor property dialogue box. Is
this some VB code? The normal color fill icon is grayed out.
Thx again,
Mr. V

"Bob Umlas" wrote:

Click on the button, select a color from the pallette in the BackColor
property

Bob Umlas
Excel MVP

"Mr. V" Mr. wrote in message
...
Hello Everybody!
Can someone tell me how to change the color of a button in a form. I am
making a form and the default color of the button is grey, is there any

way
of changing that color?
Thx,




  #4  
Old April 5th, 2005, 12:23 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

When you write "form", do you mean a UserForm?

Or do you mean a worksheet that's designed to look like a Form?

Or even a dialog sheet?

If you meant the worksheet (or dialog sheet), and you used a button from the
Forms toolbar, then you can't change the background color.

If you used the worksheet and a commandbutton from the control toolbox toolbar,
hit the design mode icon (also on that control toolbox toolbar) and then
rightclick on your command button and choose properties. You can find BackColor
there.

If you meant the userform, click on the commandbutton and hit F4 to show the
properties window.

Mr. V wrote:

Thx for replying Bob, but I cant find the BackColor property dialogue box. Is
this some VB code? The normal color fill icon is grayed out.
Thx again,
Mr. V

"Bob Umlas" wrote:

Click on the button, select a color from the pallette in the BackColor
property

Bob Umlas
Excel MVP

"Mr. V" Mr. wrote in message
...
Hello Everybody!
Can someone tell me how to change the color of a button in a form. I am
making a form and the default color of the button is grey, is there any

way
of changing that color?
Thx,





--

Dave Peterson
  #5  
Old April 5th, 2005, 02:57 PM
Mr. V
external usenet poster
 
Posts: n/a
Default

Thanks Dave for explaining everything, I was using the worksheet form toolbar
to create the button.

"Dave Peterson" wrote:

When you write "form", do you mean a UserForm?

Or do you mean a worksheet that's designed to look like a Form?

Or even a dialog sheet?

If you meant the worksheet (or dialog sheet), and you used a button from the
Forms toolbar, then you can't change the background color.

If you used the worksheet and a commandbutton from the control toolbox toolbar,
hit the design mode icon (also on that control toolbox toolbar) and then
rightclick on your command button and choose properties. You can find BackColor
there.

If you meant the userform, click on the commandbutton and hit F4 to show the
properties window.

Mr. V wrote:

Thx for replying Bob, but I cant find the BackColor property dialogue box. Is
this some VB code? The normal color fill icon is grayed out.
Thx again,
Mr. V

"Bob Umlas" wrote:

Click on the button, select a color from the pallette in the BackColor
property

Bob Umlas
Excel MVP

"Mr. V" Mr. wrote in message
...
Hello Everybody!
Can someone tell me how to change the color of a button in a form. I am
making a form and the default color of the button is grey, is there any
way
of changing that color?
Thx,




--

Dave Peterson

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidating buttons David P. General Discussion 1 July 28th, 2004 07:07 PM
Changing sort in Report afterit is created Suzanne Setting Up & Running Reports 0 July 12th, 2004 05:55 PM
Forward and send/receive buttons not shown in customize akch Installation & Setup 1 June 1st, 2004 03:16 AM


All times are GMT +1. The time now is 06:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.