How to prevent to go to the other sheet

[Goodstart14]

Hi,
I want users to move the sheet after they insert required columns.
When they click the other sheet, I want to show message box and it says ' You didn't finish yet.'
For example, when I don't insert all data in required column in Sheet1, when I click Sheet2 , message box will be popped up.

My required column is column J and starting row is 6, but last row is not known in Sheet 1.
If cell (6,"J").Value <>"" then,(this means something in this cell)
I want users to ask fill out every cells in row 6 if they omit some cells in row 6.
If users ignore , and then go to Sheet 2 , then I want to display message box to warn them.

Any advise appreciated
Thanks

[mohan.pandey87]

Method1:
Eithere you can hide all rows/columns in that particular sheet and on that particular sheet's Activate event write a code to check the columns are filled or not. If filled unhide all rows/columns and if not then show a message to the user "You didn't finish yet." and activate the data sheet.

Method2:
When user go to the next sheet write a code in sheet activate event which will check the particular condition

Method3:
Make very hidden or simply hide the sheet and provide a button in data sheet which will redirect to the next sheet and write code to check the condition and if condition is true then make that sheet visible or else show your messge.

[millz]

It's unclear what you really want to do.
How many columns/cells within a row is mandatory?
Are you going to loop through every (entered) row,
or stopping just after checking row 6?

This (ultra basic code) could be a start, place it within Sheet1's code:

Please Login or Register  to view this content.

[Goodstart14]

Thanks.
I have to loop through every row and add code in worksheet deactivate, then worked.
Thanks1

[Goodstart14]

Thanks for your help.