splash screen macro problem

[PKyle]

I have a splash screen to open up a spreadsheet, driven through vba. The
object and text boxes within have background colors, so needless to say, I
was not pleased to see no visible text while running the program from my
laptop= the text and boxes were both dark grey. Is there a way to define
the colors by code instead of box 'properties' which are system colors? I
want the box as well as the objects inside to be white, text to be black.

Thanks

Paul

 

[Tom Ogilvy]

Sure for the textboxes if they are from the control toolbox toolbar.

for the worksheet you would need to set the interior color of the cells (and
possibly apply borders as well to get the grid effect).

 

[PKyle]

I'll have to check again - I believe it is a userform- not a spreadsheet
itself .
Thanks
Paul

 

[Tom Ogilvy]

Use the backcolor property for the Userform and the controls.