Focus activecell after display of modeless userform

I am using a technique to display a modeless userform to display to the user that the cell data validation has failed (or not) after checking cell data entry (with checks coded as required).

I am using this method for a number of reasons -
- enables more flexibility and more characters over that of in cell data validation error messages
- to reduce repeat of validation data (to reduce file size) as worksheet has large qty of rows with large qty of columns with variation of validation requirements for each column.

But in the event that data is invalid (fails validation), once the modeless userform is displayed, i want the focus to be on the current cell, not the userform, otherwise the user will always have to click the worksheet to to get focus to enable entry to cell of corrected data.

Any solutions would be much appreciated

Not sure, it might help to see your code. maybe

Please Login or Register  to view this content.

I'm not too sure what you want, but don't show the form unless the cell has an entry in it

Please Login or Register  to view this content.

Use

Please Login or Register  to view this content.