Vba userform issues with black cells

[Kargg0]

I don’t see any posting on this issue anywhere!
i have a .xlsx that has two user forms- 1 is to enter new data which can be recorded to a worksheet and the 2nd is to source the worksheet and edit a particular row of selected data-
My company uses win7. The problem I am having is as follows- when me or my boss open up the tool and test it works awesome!; but I had two other future users open up the edit userform to test and when they select and bring in a row of data to edit, all the data comes in but for some reason text boxes and list boxes in the first tab are black. I checked my properties and my code and nothing is showing a problem- the background is set to white in properties!...is there some advanced property that I am missing that users would need to fix on their local box? Or is there another issue I am overlooking?

 

[bugmonsta]

I have not heard of this but as a quick fix you could set the colour of your fields when the form loads?

Below is my test script I have taken from one of my files and put against a basic userform with a textbox, a combobox and a list box - changed the colour to light blue background and blue text:

Private Sub UserForm_Initialize()
On Error Resume Next
Dim ctl2 As Control
For Each ctl2 In UserForm1.Controls
            If TypeName(ctl2) = "ComboBox" Or TypeName(ctl2) = "TextBox" _
            Or TypeName(ctl2) = "ListBox" Then
         
                ctl2.BackColor = RGB(155, 233, 247)  ' light blue
                'ctl2.BackColor = vbWhite
                ctl2.ForeColor = vbBlue
                'ctl2.ForeColor = vbBlack
                ctl2.Font.Bold = False
            End If
                Next ctl2

End Sub

 

[Kargg0]

Thanks for the code.. I will use in future since it was a desire to change some colors of certain fields. I was perturbed about this issue so I went in and just removed the boxes and put in new ones with the same names and the user said it resolved issue.