Hi David
and only the OP knows <vbg

I first also thought the OP meant real rextboxes but seeing this column
A, B statement I assumed the OP simply misspelled :-)


--
Regards
Frank Kabel
Frankfurt, Germany


David McRitchie wrote:
Interesting in rereading the posting by Scott n' Shelly said "text
boxes" but indicates Columns A and B.

I think there may be a problem in terminology here and Frank and Don
may
be clairvoyant. If it is to be text boxes and column A & B it
would have to be know which corner of a textbox is to be checked if
it is in Col A or Col B.

Help answer wizard textbox Add a text box to a chart (or to
a worksheet)

---
"scottnshelly " wrote
in message
I want whatever the user puts into the text boxes to be in Caps.
i
don't care when it changes, whether when they type it, before it
goes into the cell or whatever, just as long as at the end of the
day everything in columns A and B are in all caps.