View Single Post
 
Old 08-14-2019, 08:41 AM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

the tab is being applied to the txtPrice contorl.

Code:
Private Sub tbxItemText_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
  Select Case KeyCode
    Case vbKeyReturn, vbKeyTab
      With tbxPrice
        .SetFocus
        .SelStart = 0
        .SelLength = 4
      End With
      KeyCode = 0
  End Select
End Sub

Private Sub UserForm_Initialize()
  tbxPrice.Text = "0.00"
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote