Upper case headache!

  • Thread starter Thread starter tdx99
  • Start date Start date
T

tdx99

Hi all,

I'm a newbie when it comes to macros and VBA. I'm modifying a workbook
that has all data in upper case. The data I need to add to the sheet
must be in upper and lower case. Reading through the archive didn't
come up with anything similiar.

Is there any way override the macro so that certain cells aren't forced
to upper case?

Any input would be appreciated.

-Tua Xiong
 
If a macro is changing all worksheet entries to uppercase then the macr
would need to be modified

Is it possible to enter your text as a formula to overcome you
problem

="This Is A Test
 
Mudraker,

I did a little digging and found that it was actually a VB code that is
changing the entries to uppercase.

Typing text as a formula still forces it to uppercase.

Here is the code:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
Application.EnableEvents = False
Target = UCase(Target)
Application.EnableEvents = True
End Sub

Like I said, I'm cluesless when it comes to macros and codes.
If you or anyone can modify it so that it will allow for lowercase
entries as well, I would greatly appreciate it.

-Tua Xiong
 
Hi Tua ,
To remove the event macro entirely, simply right click on the
worksheet tab, view code, and remove the lines you posted
that appear under "Options Explicit"

If you look at my examples in proper.htm and in event.htm you will
usually see that they limit themselves to a particular column rather
applying to the entire worksheet as the event macro you displayed.

[Posted directly to USENET, no connection to excelforum or any HTML based interface]
 
Back
Top