I am using Excel with a bar code reader to record tools being checked out of tool crib . inputting into a table 4 columns wide
and after last input I need the cursor to return to beginning of next line. I am already using a worksheet_change routine to enter date in last cell
that doesn't change tomorrow so can't use another one to return cursor. I'm thinking a macro to return it but need advice on how to run it after last entry.
return the cursor to the first column of the next row? Do you advance through the columns with the tab key? Does the enter not suffice?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Bar code reader is the only way to input
How do you advance columns?
The bar code reader is programmed to advance to next column
You can try this:Is the scanner set up to advance to column E after the data is placed in column D?
Please Login or Register to view this content.
That worked, thanks for your help
Glad to help. If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks