Solved: all caps combo box

[av8tordude]

is there a way that I can make a combo box enter all cap letters when I type without the Caps lock key?

[Bob Phillips]

Why would you need to? If you need aps, upshift what they enter.

[mdmackillop]

Private Sub ComboBox1_Change()
ComboBox1.Value = UCase(ComboBox1.Value)
End Sub

[av8tordude]

thank you mdmackillop. works great! one less key to press.:friends: