modal input method?

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 use a VBA InputBox.

Originally Posted by Norie

Just use a VBA InputBox.

Thanks Norie but the vba inputbox doesn't allow you to tell the difference between user cancels and user 'ok's (without input) while the method lets you differentiate. The input function returns an empty string ("") for both actions. So I was wondering if there was a way to use the method but make it modal? Don't want the user to be able to get to the speadsheet, but do want to be able to tell if cancel or empty string.

Right now the vba inputbox is it: and, if an MT string then a msgbox " you clicked cancel or clicked 'OK' without entering a date" "Do you want to continue?" vbyesno..code..code..code.

I was wondering if there was any way to combine the "best" features of both?

Thanks again for taking the time to reply,

John

if(StrPtr(Input_Message)=0) then it means user has pressed the cancel button. I think this would help you.

I just read the cross posting rules (on another forum) and the rules here are essentially the same so I disclose that I posted this question here:

http://www.excelguru.ca/forums/showt...-with-modality

and here:

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

The InputBox does allow you to tell if Cancel is pressed.

Please Login or Register  to view this content.

Originally Posted by Norie

The InputBox does allow you to tell if Cancel is pressed.

Please Login or Register  to view this content.

Norie,

What would happen if the user clicked 'OK' without entering any input?

John

John

Sorry, you are right that would give the same result.

It's late here, that's my excuse.

Try Sindhus' answer - it works.

Originally Posted by Norie

John

Sorry, you are right that would give the same result.

It's late here, that's my excuse.

Try Sindhus' answer - it works.

not a problem I'm the beggar here

john