ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   command button colour (https://www.excelbanter.com/excel-discussion-misc-queries/261278-command-button-colour.html)

Steve Davis

command button colour
 
hi i have 3 form button at the moment that when u click run there code
and they also change the colour of the text from green to red and the next
buton from red to green that way if u get pulled away u now were u are but
would like to use command buttons as u can change the face colour not just
the text is there a vb code to change the button colour if so could u please
tell me

Jim Cone[_2_]

command button colour
 

youcancoloracommandbuttonusingcodesimilartothefoll owing:CommandButton1.BackColor=RGB(111,222,333)
--
Jim Cone
Portland, Oregon USA



"Steve davis"
wrote in message
...
hi i have 3 form button at the moment that when u click run there code
and they also change the colour of the text from green to red and the next
buton from red to green that way if u get pulled away u now were u are but
would like to use command buttons as u can change the face colour not just
the text is there a vb code to change the button colour if so could u please
tell me

Steve Davis

command button colour
 
hi thanks very much spent a bit of time looking at posts then the net so
thanks again

"Jim Cone" wrote:


youcancoloracommandbuttonusingcodesimilartothefoll owing:CommandButton1.BackColor=RGB(111,222,333)
--
Jim Cone
Portland, Oregon USA



"Steve davis"
wrote in message
...
hi i have 3 form button at the moment that when u click run there code
and they also change the colour of the text from green to red and the next
buton from red to green that way if u get pulled away u now were u are but
would like to use command buttons as u can change the face colour not just
the text is there a vb code to change the button colour if so could u please
tell me
.



All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com