I have the following code in a macro
This gives me a message box with an OK button and a cancel button. How do i change to just an OK button?Please Login or Register to view this content.
I have the following code in a macro
This gives me a message box with an OK button and a cancel button. How do i change to just an OK button?Please Login or Register to view this content.
Hi adam2308,
You can use vbOkOnly.
eg.
Hope this helpsPlease Login or Register to view this content.
There are only 10 types of people in the world:
Those who understand binary, and those who don't!
I guess the question would be why you need a variable if you have a predetermined response - and that is more of a warning than a choice, ie why not just:
I'm not sure I see the value in having a variable assigned to the response.Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
the second reply is correct and this wold suit best. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks