How do you or can you force CAPS (capital letters only) in a textbox in a macro?
Do they really need to display as all CAPS in the text box or do they just need to be used as all CAPS in your code?
If its just for usage, you could add a UCASE() method to your code to force the input to be converted to uppercase when it is used.
If you really want to change the value in the text box, you could use an event handler to change the value.
Use the change event to fire something like this:
Private Sub TextBox1_Change()
TextBox1.Text = UCase(TextBox1.Text)
Thanks, i forgot about UCase....been a long day
Retrieving data ...