QTE,

Post the On_Entry Event code that you are currently using.

HTH,
Bernie
MS Excel MVP

"QTE " wrote in message
...
Hi Excel Forum,

I am using Excel for Windows 95 v7 (isn't there always one!): I do not
have access to VBA Worksheet Change Event ByVal Target. However, if
possible, I would like to change text entered in a cell to uppercase on
data entry; I know how to change the text to uppercase once it is
already entered.

Can Excel version 7 VBA convert text to uppercase on data entry.
Columns involved C, G, J, and R.

I have already used the On_Entry Event in this particular worksheet,
can it be used again but distinguishing a particular range of columns
"ONLY" to be affected by the uppercase formatting.

Please advise of solutions within Excel V7 VBA.

If possible, please explain with a working example.

Assistance is appreciated.

Kind regards,
QTE


---
Message posted from http://www.ExcelForum.com/