Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB UserForm
If I want to change the case from lower case to upper case in the following location I can use the following code. Dim cell As Range For Each cell In Range("F3").Cells If cell.HasFormula = False Then cell = UCase(cell) Next How do I achieve the same result if the location is a TextBox created in a UserForm. ie TextBox1 in UserForm1 -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=507615 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB UserForm
Me.TextBox1.Text = UCase(Me.TextBox1.Text) If code is not in the form change "Me" to the form name Note this will trigger the TextBox Change event if you are using it. If necessary set a (global) boolean flag to True/False either side of the above code to early exit the event and re-set to false when done. Private Sub TextBox1_Change() If bExit Then Exit Sub End Sub Regards, Peter T "grahammal" wrote in message ... If I want to change the case from lower case to upper case in the following location I can use the following code. Dim cell As Range For Each cell In Range("F3").Cells If cell.HasFormula = False Then cell = UCase(cell) Next How do I achieve the same result if the location is a TextBox created in a UserForm. ie TextBox1 in UserForm1 -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=507615 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |