Prev: Opening Lotus Files in Excel 2007
Next: To find the same price in another sheet
From: Steve davis on 12 Apr 2010 12:38
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
From: Jim Cone on 12 Apr 2010 12:54

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



"Steve davis" <Stevedavis(a)discussions.microsoft.com>
wrote in message
news:847E2866-484B-4127-B0AF-8C7946C4AD95(a)microsoft.com...
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
From: Steve davis on 12 Apr 2010 13:40
hi thanks very much spent a bit of time looking at posts then the net so
thanks again

"Jim Cone" wrote:

>
> youcancoloracommandbuttonusingcodesimilartothefollowing:CommandButton1.BackColor=RGB(111,222,333)
> --
> Jim Cone
> Portland, Oregon USA
>
>
>
> "Steve davis" <Stevedavis(a)discussions.microsoft.com>
> wrote in message
> news:847E2866-484B-4127-B0AF-8C7946C4AD95(a)microsoft.com...
> 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
> .
>
 | 
Pages: 1
Prev: Opening Lotus Files in Excel 2007
Next: To find the same price in another sheet