Message Box Issue

[jamer02]

Hey guys,

I have the following piece of code:

Please Login or Register  to view this content.

Now, for some reason, the message box only comes up with a Yes No option for the "ElseIf" statement and for the "If" statement above it, the only option for the user to click is "OK", however I would like this to be the other way round, how can I do this?

Any ideas will be greatly appreciated.

Jamer

[MarvinP]

Hi Jamer and welcome to the forum,

I don't like (worry about) your code in the ElseIf line:
You have MsgBox("prompt",buttons) = vbYes Then.

This may be causing the problem. It is better if you set the Response of the MsgBox and then test it in another line of code.

see http://vbatutor.blogspot.com/2009/02...-function.html
or many other examples on the web of "Excel VBA MsgBox"