Hello-
I've searched the web and can't find anything that provides the code I'm looking for or a code I can manipulate to do what I want. I'm open to any and all suggestions.
I'm no VBA expert by any means and have no formal training, but I get the basics...so be gentle
Here is my situation:
I have a user input form that was previously available via a web based application where the application is being retired, so we are being forced/asked to provide an alternate to the form via Excel. This will be forced out to multiple users on mutiple Windows version using different Excel versions.
I would like to be able to force users to input data (alpha or numeric, of any variation) into certain cells. I don't really have a preference on how it is accomplished, just so long as they put something in the certain cells before they are able to either move to the next cell or save the workbook.
I have multiple worksheets in this workbook that will need to all be able to do this same function.
Here is an example:
Worksheet A: Merged Cells B8, C8, D8 & E8 (if the merged part of this is an issue, that can be changed, and from reading through other posts, this is probably the easier course so I'll just say Cell B8 moving forward) needs to have data entered before the user should move to Cell B10. This repeats to Cell B20, and I would like for them to have to go in order.
Worksheet B: Cell B13 must have data entered before the user can go to Cell B14, but having data entered into Cell B13 also allows the user to move to C13, in the next column where C14 follows the same rules relative to C13 that B14 follows to B13.
This same scenario repeats itself through the rest of the workbook, so if I can figure out this part, I think I can figure out the rest.
I would perfer to have message boxes pop up stating "XXXX information must be completed. File not saved" once the user attempts to save the file, but locking the cells (if possible) and forcing them that way will do to.
Any help at all would be awesome...
I've searched the web and can't find anything that provides the code I'm looking for or a code I can manipulate to do what I want. I'm open to any and all suggestions.
I'm no VBA expert by any means and have no formal training, but I get the basics...so be gentle
Here is my situation:
I have a user input form that was previously available via a web based application where the application is being retired, so we are being forced/asked to provide an alternate to the form via Excel. This will be forced out to multiple users on mutiple Windows version using different Excel versions.
I would like to be able to force users to input data (alpha or numeric, of any variation) into certain cells. I don't really have a preference on how it is accomplished, just so long as they put something in the certain cells before they are able to either move to the next cell or save the workbook.
I have multiple worksheets in this workbook that will need to all be able to do this same function.
Here is an example:
Worksheet A: Merged Cells B8, C8, D8 & E8 (if the merged part of this is an issue, that can be changed, and from reading through other posts, this is probably the easier course so I'll just say Cell B8 moving forward) needs to have data entered before the user should move to Cell B10. This repeats to Cell B20, and I would like for them to have to go in order.
Worksheet B: Cell B13 must have data entered before the user can go to Cell B14, but having data entered into Cell B13 also allows the user to move to C13, in the next column where C14 follows the same rules relative to C13 that B14 follows to B13.
This same scenario repeats itself through the rest of the workbook, so if I can figure out this part, I think I can figure out the rest.
I would perfer to have message boxes pop up stating "XXXX information must be completed. File not saved" once the user attempts to save the file, but locking the cells (if possible) and forcing them that way will do to.
Any help at all would be awesome...
