Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank that worked, I do one other problem when the item is scanned I
sometimes get $/ is there away to check each character to do the same as below? "Rick Rothstein" wrote: What does the "Call bntEnabled" statement do? I'm guessing that it is probably setting focus to another control. You can overcome this problem by changing the TextBox's HideSelection property to False; then it will still show the selected text even if some other control has focus. -- Rick (MVP - Excel) "vqthomf" wrote in message ... Hi I was wondering if someone can help I am trying to highlight text in a textbox if the user miss scan an item into a textbox, I am using the code below but I can't get it to work any help would much apprecated. Regards Charles Private Sub txtVin_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) ' If KeyCode = 13 Then If Len(txtVin.Value) = 17 Then Call Vinchk Else MsgBox "Sorry there are not enough character,Please re-scan the Vin." With txtVin .SetFocus .SelStart = 0 .SelLength = Len(.Text) 'I have also tried .TextLength End With End If End If Call bntEnabled End Sub . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlight text in textbox | Excel Programming | |||
Highlight text in Textbox | Excel Programming | |||
Highlight the contain of textbox and radio button | Excel Programming | |||
highlight text in userform textbox | Excel Programming | |||
Highlight all Text in a Textbox when the textbox is selected | Excel Programming |