Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifing a userform txtbox code
On Jun 13, 8:21 am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote: js, Try If blkProc Then Exit Sub If Len(Me.textbox1.Value) = 10 Then ActiveCell.Value = Me.textbox1.Value blkProc = True Me.textbox1.Value = "" blkProc = False ActiveCell.Offset(1, 0).Activate End If HTH, Bernie MS Excel MVP wrote in message oups.com... Below is a code for a text box in a userform that accepts one character and then goes to the next cell. How do i modify it to accept ten characters and then move to the next cell. Thanks Private Sub TextBox1_Change() If blkProc Then Exit Sub ActiveCell.Value = Me.TextBox1.Value blkProc = True Me.TextBox1.Value = "" blkProc = False ActiveCell.Offset(1, 0).Activate End Sub- Hide quoted text - - Show quoted text - Thanks Bernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED HELP MODIFING A CELL | Excel Discussion (Misc queries) | |||
modifing the find function | Excel Discussion (Misc queries) | |||
Modifing a recorded macro. | Excel Programming | |||
VBA question - Inputing data to txtbox in userform using short date formart | Excel Programming | |||
txtbox code | Excel Programming |