2 more userform questions

[mortgageman]

1) can option boxes be "greyed out" (based on a condition of course)

and

2) Can text boxes be set to a different color?

Gene, "The Mortgage Man", Klein

 

[stdz]

Hello Gene,

Yes you can do both of these:

1) To "grey out" CheckBoxes or OptionButtons, set the
"Enabled" property to False.

2) For TextBox color, set the "BackColor" property to the
appropriate color.

Ciao,

Don.

 

[mortgageman]

2) For TextBox color, set the "BackColor" property to the
appropriate color.

Are these back color properties numbers, or are they "vb"constants (like vbCrLf is the constant for Enter in VBA)

Gene, "The Mortgage Man", Klein

 

[XLGibbs]

You can set the color in the properties window of the text box next to back color, or you can set up change events in other objects to toggle the enabled.true/false proprety of your buttons.

For example, if TextBox2 has text entered you could enter this in TextBox2 after uptate

TextBox2_AfterUpdate()

TextBox1.Enabled = True

End Sub

If a certain condition needs to be met to enable the button

TextBox2_AfterUpdate()

If TextBox2.Text = "monkeynuts"  ' change monkeynuts to your desired text"
TextBox1.Enabled = True
End IF

End Sub

You can likewise change otherpropeties such as .visible etc the same way on certain events for other objects on your form.

Obviously change textbox1 to optionbox1 etc as needed to suit.

 

[Norie]

Gene

I just tried these and they worked.

TextBox1.BackColor = vbGreen

TextBox1.BackColor = vbRed

 

[mortgageman]

Norie - thanks - thats exactly what I needed (I should have tried it myself ofcourse, but oh well)

Gibbs - I'm not sure what question of mine you were answering, but thanks - you gave me a lot of stuff to work with.

Gene, "The Mortgage Man", Klein