Row Entries

[ragrone]

I am looking for vba code that will do two things, and I am certain it's not that difficult however, I do require some assistance.

I would like to control the direction of the data entry on an Excel sheet to move from left to right in a row to a certain column then, proceed to the next row with a twist.

I need to make certain that certain fields per row require input and if nothing is inputted in the cell to the left, (that is moving left to right) that, an alert would flag the user that, the previous cell cannot be left blank.

Not all cells in the row are required just certain cells, some cells maybe grouped together while, other cell inputs are not required, example.

Date - Item # - Primary Contact - Secondary Contact - Street Address

In this case, the Item # is mandatory which, fills the date field in automatically once entered next, the Primary Contact is required following the Secondary Contact will not always be required, and then the Street Address would be required.

Any help would be greatly appreciated.

[Sean Thomas]

why don't you create a userform.
this does a number of things.
you can prevent users free typing anything in.
data validation can be used before entering the data onto the sheet
dates will always be in the same format.

[Sean Thomas]

Hi
try this for example

[ragrone]

Thanks for the suggestion Sean however, I am getting a runtime error stating "objects unavailable on this machine" it's still early though, and I was up late...

I was probably looking for a simple row statement something that stated: Here's what I have been working with so far:

Please Login or Register  to view this content.

Which is obviously auto filling the date in column one after inputting some text in column B... what I needed was the statement to not allow any input in column "C" unless input in Column "B" was accomplished, and so on. In addition, I need column "A" to simply increment by "1" to indicate the item reference number.

So, I have this much working and have attempted to add a statement:

Please Login or Register  to view this content.

To increment the reference number in Column "A" however, it simply returns the number "1" in every row in that column...

I think if I could get some help making the original code to disallow any further information from being added in the row, unless the information in column "C" has been added then, I am on my way