Thread: Textbox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default Textbox

Hi Jim,

using textbox_change event you can change its value to upper case.

Something like this:

Private Sub textboxA_Change( )
application.enableevents=false
textboxA.value=ucase(textboxA.value)
application.enableevents=true
end sub

I hope I didn't mistype, I wrote it from scratch, didn't test it in
VBA.

Regards,
Ivan