Hi Excel Forum,

I am using Excel for Windows 95 v7 (isn't there always one!): I do no
have access to VBA Worksheet Change Event ByVal Target. However, i
possible, I would like to change text entered in a cell to uppercase o
data entry; I know how to change the text to uppercase once it i
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 column
"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,
QT

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