using a bar code reader need to drop down a cell automaticaly once data is entered

J

john iles

i need to use a bar code reader (this is just a high speed keyboard)
i click the button then it types the bar code data in the current cell
once that is done i need to automaticaly "drop down" to the cell below
to continue with the next bar code reading
i tried to get a macro to do this "drop down a cell"problem is i cant
get a macro to run until i exit the active cell
therfore i am stuck in a loop

any ideas
 
J

jaf

Hi John,
Do you have a <cr> at the end of the data?


--
John
johnf 202 at hotmail dot com


| i need to use a bar code reader (this is just a high speed keyboard)
| i click the button then it types the bar code data in the current cell
| once that is done i need to automaticaly "drop down" to the cell below
| to continue with the next bar code reading
| i tried to get a macro to do this "drop down a cell"problem is i cant
| get a macro to run until i exit the active cell
| therfore i am stuck in a loop
|
| any ideas
 
B

Bernard Liengme

Is there a setting on the 'wand' to add <CR> when you release the button?
 

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

Top