Problem with UserForm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
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

--------------------------------------------------------------------------------------
 
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

--------------------------------------------------------------------------------------
 
Back
Top