Dialog/Form box allow screen interaction?

[Ouka]

Hi All,

Stupid question, answer isn't in one of my reference books that I've seen so far:

Is there a type of dialog box or form setting that will allow worksheet/form interactions of screens under the dialog box while leaving said box on top of all the other screens?

i.e. I want to pop up a warning dialog box to my users but allow the user to make final review/edits to the data before continuing. So I would like to leave a moveable dialog box open while my users click under it to the worksheets/forms that are open.

Is this possible?

 

[Tom Urtis]

UserForms and Message Boxes both have a modal property that can be set to false, allowing for the kind of interaction with the worksheet you are asking about.

It is possible for a message box to be modeless, so that it can float on the screen and stay visible as you scroll and select various worksheet ranges:

 Private Declare Function MessageBox _
        Lib "User32" Alias "MessageBoxA" _
           (ByVal hWnd As Long, _
            ByVal lpText As String, _
            ByVal lpCaption As String, _
            ByVal wType As Long) _
        As Long
 
Sub ModalMessageBox()
MessageBox &H0, "This is a modeless Message Box", "Modeless test", vbSystemModal
End Sub

For userforms, call the form as
UserForm1.Show 0

where 0 = False, or vbModeless

 

[doofusboy]

Just change your form's 'ShowModal' property to 'FALSE' to get the functionality you are looking for.

 

[Ouka]

Thanks all, knew it was a stupid question. Hard to find something in a reference book when you don't know the name of the feature!

-o