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

  • Thread starter Thread starter john iles
  • Start date Start date
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
 
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
 
Back
Top