Is there a way to use input method with modality?

**JOHNNYC** · 2012-11-01, 01:32 AM

Programmers,

I like the way the input method allows vba to check if the user clicks cancel or clicks 'ok' without any input. However, for my purposes, it is a disadvantage that application.input allows the user to access the workbook (it is modeless). So the question is: is there a way to make the input method modal?

John

**JOHNNYC** · 2012-11-02, 05:48 AM

Just read the cross posting rules I posted this question here:

http://www.excelforum.com/excel-prog...ut-method.html

and here:

http://www.ozgrid.com/forum/showthre...066#post635066