| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PHP isset function in VBA
Just a quick one. Is there a similar function in VBA as the isset function in PHP, i.e. function which returns true if a variable is set. Cheers -- Tomsk ----------------------------------------------------------------------- Tomski's Profile: http://www.excelforum.com/member.php...fo&userid=2682 View this thread: http://www.excelforum.com/showthread.php?threadid=50672 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PHP isset function in VBA
hi, Have a look in the VBE help files at the explanations for "isnull" "isempty". One of these should do what you are after. hth Rob Brockett NZ Always learning & the best way to learn is to experience.. -- broro18 ----------------------------------------------------------------------- broro183's Profile: http://www.excelforum.com/member.php...fo&userid=3006 View this thread: http://www.excelforum.com/showthread.php?threadid=50672 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PHP isset function in VBA
A friend suggested comparing the variable to "IS Nothing" which seems to work if anybody was wondering. Cheers Tom -- Tomski ------------------------------------------------------------------------ Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824 View this thread: http://www.excelforum.com/showthread...hreadid=506720 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PHP isset function in VBA
Cheers for the suggestion Rob, the IS function as you suggested is wha I was looking for. Because I am checking if a function that returns range has worked, the IS nothing is the one to use. -- Tomsk ----------------------------------------------------------------------- Tomski's Profile: http://www.excelforum.com/member.php...fo&userid=2682 View this thread: http://www.excelforum.com/showthread.php?threadid=50672 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PHP isset function in VBA
no problem, pleased I could help. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=506720 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PHP isset function in VBA
no problem, pleased I could help. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=506720 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
![Tomski[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
