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
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-prog...ut-method.html
and here:
http://www.ozgrid.com/forum/showthre...066#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.)
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks