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?
 
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
 
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.