Is there anyway to tell from a form whether it was called modeless or not?
i.e. Would it be possible to have a boolean function placed in a userform module and called from the form initialize event - which would return True/False value so you know whether the form was shown as .Show or .Show vbModeless?
(This question is out of curiosity/increase theoretical knowledge only. No practical use that I can think of).
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
well you just could set a hidden textbox on the userform to carry the property.
Alternatively, I suppose
UserForm1.show
would return an error if it was already displayed modally, whereas it would not return an error if it was displayed modelessly. So you could use that to test.
I do not think there can be a direct way because the userform has no property for this and the style bits of the window do not change whether it is modal or modeless.
True. But I wanted to know if it could be determined from the form without passing anything to determine how it was called.Originally Posted by yudlugar
Bingo. That's what helped me solve it. +1
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks