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
Bookmarks