Trying to find VBA code for Excel

I am looking to build a form in Excel. I am recreating a form that we use for ordering, it requires me to put a single value in a cell then go to the next. Is there VBA code i can use to auto  tab between the cells? Or overlay textboxes to string the cells together? Any help would be appreciated!
Comm_NavAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

patrickabCommented:
Go to Tools/Option/Edit and select the 'Move direction after Enter'

Patrick
0
patrickabCommented:
Comm_Nav, Pre

To append one string to another use: =A1&B1&C1 So for example if:

A1 contains 'one'
B1 contains 'two'
C1 contains 'three'

Then if a cell has this formula: =A1&B1&C1

It will give: onetwothree

Patrick
0
Comm_NavAuthor Commented:
The issue is where we have to enter a number, ie 5999002806458 into multiple cells like 5 {tab} 9 {tab} 9 {tab} 9 {tab} 0 {tab} 0 {tab} 2 {tab} so on and so on. The from we have now we have to enter it like this. We are tring to automate it so you enter the number and it automatically tabs after the number into the next cell. Would it be easier to turn the cells into text boxes?
0
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

patrickabCommented:
>Would it be easier to turn the cells into text boxes?

No it wouldn't.

If you have an absolutely set pattern of data entry you might consider creating a macro to allow you to anter all the data onto a Userform first and then when you had checked the data, press one button to enter it all in one go, ready for the next set of data.

If that's what you are needing then please upload your file with exact instructions of what is required. Only a very small example set of non-private data is needed.

Patrick
0
Comm_NavAuthor Commented:
Here is the form we are trying to create to replace the old form.
2005-2.xlsx
0
patrickabCommented:
Please remove the password and upload it as an .xls file type. If you have macros in the .xlsx file you will not be able to upload it here - thus the need to upload only an .xls file type.

Patrick
0
Comm_NavAuthor Commented:
Sorry, I forgot that we locked the form to control what the users could edit. Here it is now.
2005-2.xls
0
Comm_NavAuthor Commented:
Under the Stock Number and Document Number you can see how each cell is just for one number. Stock Numbers are ie: 9999999999999, document numbers are ie: X999XX9999999. We are trying to create it where it is a time savings for us.
0
patrickabCommented:
Comm_NavDat,

In the attached file I have started a worksheet_change macro which I am going to leave you to complete - as it is seriously boring to write it. Im sure you will very quick grasp the simple idea behind it.

After data entry in a cell it moves the cursor onto the next cell ready for data entry. If no data is entered and Enter is pressed the cursor will move to the right.

Hope it helps

Patrick
EntryForm-2005-01.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.