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
|