View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 57
Default All uppercase characters

For the following line of code:

UserVal = Application.InputBox("Symbol?", , , , , , , 2),

irrespective of what I type, when it is later retrieved, I'd like all the
characters stored in UserVal to be uppercase, not lowercase. So, if I type
"ibm," I'd prefer it to be saved as "IBM." It'll save me toggling the Caps
Lock key on and off!

My thanks in advance for any help. Brad