Close UserFom if cell formatting doesn't match

[stberger]

Hello Everyone,

Following situation: I open an UserForm (particularly a calendar) by clicking a cell which matches the formatting (d mmm yy) with the following code:

Please Login or Register  to view this content.

To close the UserForm I have to click the close button on the right top corner.
Question: is it possible to close the UserFform by clicking any cell which does not have the same formatting or by clicking another cell with the matching formatting then the UserForm will close and reopen? Not sure if this is possible in general, please let me know.

Many thanks,
Stefan

[MarMo]

Just a thought.
Could this be of help?

Please Login or Register  to view this content.

use this if you only want a range of cells to be checked.

Please Login or Register  to view this content.

I also uploaded the sample workbook with a sample userform.
The ShowModal attribute in the properties window is set to : FALSE.
This will give you a userform on top, but the sheet is still available.

I used a format BOLD and color RED to get the format of a selected cell.
If TRUE then the UserForm is closed.
IF FALSE the UserForm will be opened.

[stberger]

Hi MarMo,

Thanks a lot for your help. The ShowModal attribute was what I was looking for.