Is there a way to use input method with modality?

JOHNNYC

New member
Joined
Jul 8, 2012
Messages
14
Reaction score
0
Points
0
Location
Texas
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
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Hi John,

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