Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UserForm
I created a single UserForm with only a Label in it. I left the default
colors for the UserForm and Label alone. I also left all the other properties at their default settings. But when I execute the code to display the UserForm, all I see is a white box with a blue border and a blue caption area. I don't see any text! Can anyone tell me what I either did wrong or missed? Thanks in advance for any guidance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UserForm
What's white? What's the default color?
"Bob" wrote in message ... I created a single UserForm with only a Label in it. I left the default colors for the UserForm and Label alone. I also left all the other properties at their default settings. But when I execute the code to display the UserForm, all I see is a white box with a blue border and a blue caption area. I don't see any text! Can anyone tell me what I either did wrong or missed? Thanks in advance for any guidance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UserForm
Hi,
Did you check the code to run your UserForm? Whether the code to run UserForm is using API calls with incorrect variable or constant -- Regards, Halim "Bob" wrote: I created a single UserForm with only a Label in it. I left the default colors for the UserForm and Label alone. I also left all the other properties at their default settings. But when I execute the code to display the UserForm, all I see is a white box with a blue border and a blue caption area. I don't see any text! Can anyone tell me what I either did wrong or missed? Thanks in advance for any guidance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UserForm
UserForm1 & Label1 Color Properties:
BackColor = &H8000000F& (Button Face) ForeColor = &H80000012& (Button Text) Code to run UserForm: UserForm1.Show Code contained in module for UserForm: Private Sub UserForm_Activate() Call CopyTransposeData Unload UserForm1 End Su ---------------------------------------------------------------------------------- "Bob" wrote: I created a single UserForm with only a Label in it. I left the default colors for the UserForm and Label alone. I also left all the other properties at their default settings. But when I execute the code to display the UserForm, all I see is a white box with a blue border and a blue caption area. I don't see any text! Can anyone tell me what I either did wrong or missed? Thanks in advance for any guidance. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UserForm
UserForm1 & Label1 Color Properties:
BackColor = &H8000000F& (Button Face) ForeColor = &H80000012& (Button Text) Code to run UserForm: UserForm1.Show Code contained in module for UserForm: Private Sub UserForm_Activate() Call CopyTransposeData Unload UserForm1 End Sub -------------------------------------------------------------------------------------- "Halim" wrote: Hi, Did you check the code to run your UserForm? Whether the code to run UserForm is using API calls with incorrect variable or constant -- Regards, Halim "Bob" wrote: I created a single UserForm with only a Label in it. I left the default colors for the UserForm and Label alone. I also left all the other properties at their default settings. But when I execute the code to display the UserForm, all I see is a white box with a blue border and a blue caption area. I don't see any text! Can anyone tell me what I either did wrong or missed? Thanks in advance for any guidance. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UserForm
UserForm1 & Label1 Color Properties:
BackColor = &H8000000F& (Button Face) ForeColor = &H80000012& (Button Text) Code to run UserForm: UserForm1.Show Code contained in module for UserForm: Private Sub UserForm_Activate() Call CopyTransposeData Unload UserForm1 End Sub -------------------------------------------------------------------------------------- "-" wrote: What's white? What's the default color? "Bob" wrote in message ... I created a single UserForm with only a Label in it. I left the default colors for the UserForm and Label alone. I also left all the other properties at their default settings. But when I execute the code to display the UserForm, all I see is a white box with a blue border and a blue caption area. I don't see any text! Can anyone tell me what I either did wrong or missed? Thanks in advance for any guidance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform problem? | Excel Discussion (Misc queries) | |||
userform problem | Excel Programming | |||
Userform from a Userform Problem | Excel Programming | |||
SOme problem on VBA Userform | Excel Programming | |||
UserForm Problem | Excel Programming |