Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a function which basically returns a found shape if succeed. But
what if nothing could be found and nothing is returned? How to judge this in its calling code? Function findShape(text as String) if *** then findShape = specifiedShape end if end function sub doSth() if findShape("special") then msgbox "found" end if end sub There always reports error on the line "if NOT findShape then", saying that "Object does not support this property or method". Any suggestions? Thanks, lvcha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Qestion to judge whether the candidate has passed or failed ...... | New Users to Excel | |||
Formatting worksheets, existing and new, in existing workbooks | Excel Discussion (Misc queries) | |||
determine wheter string has a number in it? | Excel Worksheet Functions | |||
how do I judge current document is a blank one? | Excel Programming | |||
Get an object representing an existing Excel instance from Outlook | Excel Programming |