| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| command button sub | Excel Discussion (Misc queries) | |||
| command button add another command | Excel Discussion (Misc queries) | |||
| Command button | Excel Worksheet Functions | |||
| Colour formatting using command buttons and comparing data. | Excel Discussion (Misc queries) | |||
| How do I change font colour in an if command? | Excel Worksheet Functions | |||
Linear Mode
