Is there a way to use input method with modality?

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

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

http://www.excelforum.com/excel-programming-vba-macros/873198-modal-input-method.html

and here:

http://www.ozgrid.com/forum/showthread.php?t=171489&p=635066#post635066

Answered on ExcelForum

Hi John,

Thanks for posting back on this, and sorry we couldn't get to your question. (Glad you got it solved though.)