splash screen macro problem
 

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

splash screen macro problem
 

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

splash screen macro problem
 

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

splash screen macro problem
 

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

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