I want whatever the user puts into the text boxes to be in Caps.
don't care when it changes, whether when they type it, before it goe
into the cell or whatever, just as long as at the end of the da
everything in columns A and B are in all caps.
Thanks

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

Hi
see: http://www.cpearson.com/excel/case.htm

--
Regards
Frank Kabel
Frankfurt, Germany


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.
Thanks.


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

The poster asked for text boxes not cells.

Putting things in all caps that should not be in caps is about as
unprofessional as you can get for an appearance.

KB 152379 - How to Copy the Text Within a Text Box to a Cell
http://support.microsoft.com/?kbid=152379
( you can Google kbid=152379)


Here is a regular macro to change text to all capitals in the textboxes
of the active worksheet.

Sub KinderTextboxCaps()
Dim tbox As TextBox
For Each tbox In ActiveSheet.TextBoxes
tbox.Text = UCase(tbox.Text)
Next tbox
End Sub


This is an Event macro (install with right on sheet tab, view code, ...)
that will change to caps upon selection of the worksheet.

Private Sub Worksheet_Activate()
' change all textboxes on the page to caps
' upon worksheet activation. DMcR 2004-07-15
Dim tbox As TextBox
For Each tbox In ActiveSheet.TextBoxes
tbox.Text = UCase(tbox.Text)
Next tbox
End Sub

has been added to:
InputBox, MsgBox and TextBox
http://www.mvps.org/dmcritchie/excel/inputbox.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Frank Kabel" wrote ...
see: http://www.cpearson.com/excel/case.htm


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.
Thanks.


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

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.

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.

Sorry for the confusion,
The userform has two textboxes. the info from textbox1 goes int
column A, textbox2 to column B. I don't care where the text get
converted to uppercase, as long as by the end of the day everything i
columns A and B are in uppercase. i don't care about professionalis
on this workbook.
In summation, It doesn't matter if the text is converted to uppercas
in the textboxes, or in the cells. either one would be fine. jus
help me make everything uppercase.
Thanks

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

try this in a before_close event in the ThisWorkbook module

Sub uscaseAandB()
mr = Columns("a:b").Find("*", searchdirection:=xlPrevious).Row
'rest is mostly McRitchie
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cell In Range("a1:b" & mr)
If cell.HasFormula = False Then
cell.Value = UCase(cell.Value)
End If
Next cell
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

--
Don Guillett
SalesAid Software

"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.
Thanks.


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