MsgBox
 

i tried to a msgbox like i usually do and get a message wen i test i
saying
"Function call on left hand side must return variant or object"

Microsoft Help is no help....i dn't understand wat it means!:confused

--
Message posted from http://www.ExcelForum.com

MsgBox
 

Hi
please post your code which throws this error :-)

--
Regards
Frank Kabel
Frankfurt, Germany


i tried to a msgbox like i usually do and get a message wen i test it
saying
"Function call on left hand side must return variant or object"

Microsoft Help is no help....i dn't understand wat it
means!:confused:


---
Message posted from http://www.ExcelForum.com/

MsgBox
 

There is no "=" after th emsgbox command
eg

MsgBox = "hello world!"
results in the error that you had.

The code should be

MsgBox "hello world"


Patrick Molloy
Microsoft Excel MVP
-------------------
I Feel Great
-----Original Message-----
i tried to a msgbox like i usually do and get a message
wen i test it
saying
"Function call on left hand side must return variant or
object"

Microsoft Help is no help....i dn't understand wat it
means!:confused:


---
Message posted from http://www.ExcelForum.com/

.

MsgBox
 

ITS SUMTHING LIKE

MsgBox("Message", vbOkOnly, "Instructions")=vbO

--
Message posted from http://www.ExcelForum.com

MsgBox
 

It isn't clear what you are trying to do, but try something like

MsgBox "Message",vbOkOnly,"Instructions"
' or
If MsgBox("Message",vbOkCancel,"Instructions") = vbOk Then
' user clicked OK
Else
' user clicked Cancel
End If

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"shasta " wrote in
message ...
ITS SUMTHING LIKE

MsgBox("Message", vbOkOnly, "Instructions")=vbOK


---
Message posted from http://www.ExcelForum.com/