Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2004
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have 8 different items ...

    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount
    quantity----------parts------------amount

    what I need to have happen is when the user enters the firts quantity, parts and amount, if that is all she is entering she does not want to keep tabbing all the wat through the other 21 area's. is there a way to do this and yet still have the data entered into my spreadsheet?
    thank u

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Is the above series on a form or in the worksheet?
    If it's on a form you can assign an accelerator key to the Save button {or however they close the form} that they can quickly type. I assume this is all because they don't want to use the mouse?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    2 Star Lounger
    Join Date
    Apr 2004
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    the data entry operator is fast so she would like to just skip the empty text boxes (thats what the quantity parts and amount are.
    so if there is quantity = 1 part = tire amount = 5 cents and nothinjg else she can skip the other text boxes and continue to the total materials text box.

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Ok, I'll assume that your entry operator will always want to make this decision at the amount fields only.
    With that in mind you need to enter the following code for the KeyUp event for each of the amount textboxes.
    Code:
    Private Sub obButtonA_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    
       MsgBox "KeyCode: " & Format(KeyCode)  ' - the msgbox is only for selecting the key number then to be deleted.
       If KeyCode = 123 Then  'F12 Key
         tbTotalMaterials.SetFocus
       End If
       
    End Sub
    Note: I used the form I created for your other question so the KeyUp events are attached to OptionButtons but they can also be attached to textboxes.

    Sample Attached.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •