Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! --- Message posted from http://www.ExcelForum.com/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox
ITS SUMTHING LIKE
MsgBox("Message", vbOkOnly, "Instructions")=vbO -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msgbox in VBA | Excel Discussion (Misc queries) | |||
MsgBox help | Excel Programming | |||
MsgBox | Excel Programming | |||
MsgBox Help! | Excel Programming | |||
msgbox | Excel Programming |