View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GSnyder GSnyder is offline
external usenet poster
 
Posts: 33
Default Barcode suffix & Prefix

Can you provide an example of what the cell result looks like? I'm trying to
imagine how the CTRL&F2 is coming through...

--
Happy calculating!

If you like this answer, please click ''Yes.''




"Dimitris" wrote:

Hello there,

I have a question and I need an answer if someone can offer me one. I have
a barcode scanner. If I will try to scan in a cell in excel will take the
barcode number in it and the default enter will move me to the cell under the
first. This is something that I want.
My problem is that my barcode has a prefix (CTRL & F2) and suffix (CTRL &
F2) because I need these prefix & suffix in my ERP. Is there any way when I
scan in excel to bypass these two. Maybe with the function "OnKey" or
something else without changing the barcode reader programming?

Thanks in Advance

Dimitris