Hi Rafaaj2000,

Ok, I found the SetBKColor function in the 'gdi32' Library and the code works
great apart from one problem :The colouring of the Formula bar is
inconsistent ie : it keeps coming and going .

Yeah, I guess Excel is setting some colouring when you edit a formula

Also, how do I set the Formula colour back to its default ?

call it again, setting a backcolour of &HFFFFFF?

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev