Changing Colour.

[louisa]

No its not, where the fields are Company, Address etc the background of that, where the order status is on the right i want that to be the same with the other info.

 

[vbaInet]

Have a look at the attached. You didn't do what I advised in post #9.

 

[louisa]

Thats perfect, i did yest however have a read through the whole thread and tried again which it then worked (obviously did something wrong the first time) all i am trying to do now is work out how i can have the tab names displayed in the header so it clearly states what form/tab you are looking at, any help with that is greatly appreciated. You have helped me out so much VBA so thank you for all your time.

 

[vbaInet]

You're welcome.

You wouldn't need to worry about that, I've made some amendments so it doesn't scroll down past the tab name. See attached.

 

[louisa]

thats perfect thank you so much your a star!