What is the equivalent of Application.DisplayAlerts in the MSForms library ?

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
9,806
Office Version
  1. 2016
Platform
  1. Windows
I am experimenting with some code that drags controls from one modeless userform and drop them onto another modeless userform. as soon as I drop the control onto the destination userform , I get the alert message : "This Method can't be used in this context" - I want to suppress this error message but Application.DisplayAlerts doesn't work for userforms.

Is anybody aware of a built-in method to suppress alerts coming from the MSForms library ?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Hi Jaafar,
AFAIK there is no method in MSForms libray similar to DisplayAlerts.
What about Cancel=True for BeforeDropOrPaste event?
Vlad
 
Upvote 0
Hi Jaafar,
AFAIK there is no method in MSForms libray similar to DisplayAlerts.
What about Cancel=True for BeforeDropOrPaste event?
Vlad

Thanks Vladimir but that doesn't work either. the alerts still popup.
 
Upvote 0
Hi Jaafar,
AFAIK there is no method in MSForms libray similar to DisplayAlerts.
What about Cancel=True for BeforeDropOrPaste event?
Vlad

Vladimir - In case you are interested, here is what this led to .
 
Upvote 0
Seems that not API solution can be used as well. Have answered in the thread on your link
 
Upvote 0

Forum statistics

Threads
1,224,568
Messages
6,179,595
Members
452,927
Latest member
whitfieldcraig

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top