help with textbox tabkeybehavior

T

techprost

Have been working with comboboxes with assoc textboxes + command buttons to
give costs of popular named beverages on separate wksheet in 'range' columns
headed 'by manufctrer'.....so that we can see how much spent on 'xxx vodka'
etc
This involves repeated commandbutton clicks after each textbox amount entered
to activate entry to column next sheet
Would like to use 'ENTER' key in sub.......to save time and make more
interesting
If you know what I mean
code being currently used is:-
sub commandbutton1_click()
Sheets("invsales").Activate
Worksheets("invsales").Range("invref").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = TextBox1.Value
End sub
Anything I can add to this code - ( have tried ONKEY - without success)
to get {ENTER} to do the work a bit easier
Grateful for any suggestions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy filtered data to sheet 2 1
Entering data from a userform into multiple sheets 2
Combobox will not show list 4
Excel UserForm issues: Textboxes cannot be blank 1
Macro to generate FileName of the source file 1
Populating a range of empty cells with usernames 4
Mutiple comboboxes on user form 1
Two types of textbox input 1

Top