Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Newbie - Simple Macro
Hey guys,
I'm very new to programminhg and VBA. I'm currently working for a photography company that has begun to use Barcoding with Excel to automate data entry. They've asked me to create a simple program with a shortcut that can be turned into a barcode. Any help on this would be appreciated, I'm a bit stuck, but eager to learn. All information scanned begins in column H. After info is scanned into the cell, the cursor automatically moves to the next cell on the right. Sometimes the row has a few more cells that require input, other times the user immediately needs to go to the next line. I need to create a barcode that when scanned will move the cursor back to row H in the next row. Simple, I know, but I'm not sure where to start. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Newbie - Simple Macro
Hi
I don't know a whole lot about barcode scanning, but I do have a barcode scanner pen and if you set col H to a barcode font and then go to Tools,options,Edit and check the "Move selection after enter" direction to "down" it should move to the next cell in col H after a scan. At least it does for me in Excel 97. HTH Ken --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 24/03/2004 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Newbie - Simple Macro
Hello,
I'm very new to programminhg and VBA. I'm currently working for a photography company that has begun to use Barcoding with Excel to automate data entry. They've asked me to create a simple program with a shortcut that can be turned into a barcode. Any help on this would be appreciated, I'm a bit stuck, but eager to learn. All information scanned begins in column H. After info is scanned into the cell, the cursor automatically moves to the next cell on the right. Sometimes the row has a few more cells that require input, other times the user immediately needs to go to the next line. I need to create a barcode that when scanned will move the cursor back to row H in the next row. Simple, I know, but I'm not sure where to start. You will likely need a 3rd party tool to manage the barcoding, like those developed by the companies at - http://www.bank-software.com/check-printing.htm Goodluck Tina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple (I bet) Newbie question... | New Users to Excel | |||
Newbie Macro Question | Excel Discussion (Misc queries) | |||
Simple excel question for newbie | Excel Worksheet Functions | |||
Simple formula for newbie! | New Users to Excel | |||
Macro Help for Newbie | Excel Programming |