Solved: Converting specific words in TextBox to Uppercase

[Andy2011]

Can anyone tell if how to code the following...

I have a series of TextBoxes that contain data entered by users. Within these TextBoxes dates will be entered as Weekdays and Months, i.e. MONDAY, JULY etc.

Is there any way to change these to Uppercase when the Command Button to submit the entry is pressed. It is only the WEEK or MONTH names I wish to convery.

This is driving me barmey......:banghead:

[macropod]

Cross-posted at: http://www.msofficeforums.com/vba/8311-day-month-uppercase.html
(where the query has already been answered - and marked as solved - before posting here)!!!

Andy, for cross-posting etiquette, please read: http://www.excelguru.ca/node/7