View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
PKyle PKyle is offline
external usenet poster
 
Posts: 15
Default splash screen macro problem

I did that- its white on my desktop and when I use my laptop, the backcolor
is grey for both the box and textboxes... so its unreadable. I feel that
its because the system color difference for the labtop is driving the
selections. I'll try it one more time tonight.

Thanks

Paul
"Tom Ogilvy" wrote in message
...
Use the backcolor property for the Userform and the controls.

--
Regards,
Tom Ogilvy

"PKyle" wrote in message
...
I'll have to check again - I believe it is a userform- not a

spreadsheet
itself .
Thanks
Paul


"Tom Ogilvy" wrote in message
...
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).

--
Regards,
Tom Ogilvy

"PKyle" wrote in message
...
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