| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Isblank check in VB
In the following code, what is the syntax for
Excel's "Isblank" function in Visual Basic? Function SpGradeEquiv(Form, Level, Score) If Isblank(Score) = True Then SpGradeEquiv = 0 Else Select Case Level Case "E" 'Level E Select Case Form Case 7 'Form 7 Select Case Score Case 0 To 5 SpGradeEquiv = 0 Case 6 SpGradeEquiv = 1...yada,yada,yada |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Isblank check in VB
Isempty(score)
-- Regards, Tom Ogilvy "Stacy Haskins" wrote in message ... In the following code, what is the syntax for Excel's "Isblank" function in Visual Basic? Function SpGradeEquiv(Form, Level, Score) If Isblank(Score) = True Then SpGradeEquiv = 0 Else Select Case Level Case "E" 'Level E Select Case Form Case 7 'Form 7 Select Case Score Case 0 To 5 SpGradeEquiv = 0 Case 6 SpGradeEquiv = 1...yada,yada,yada |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Isblank check in VB
That worked. Thanks a bunch! -Stacy
-----Original Message----- Isempty(score) -- Regards, Tom Ogilvy "Stacy Haskins" wrote in message ... In the following code, what is the syntax for Excel's "Isblank" function in Visual Basic? Function SpGradeEquiv(Form, Level, Score) If Isblank(Score) = True Then SpGradeEquiv = 0 Else Select Case Level Case "E" 'Level E Select Case Form Case 7 'Form 7 Select Case Score Case 0 To 5 SpGradeEquiv = 0 Case 6 SpGradeEquiv = 1...yada,yada,yada . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF / ISBLANK | Excel Discussion (Misc queries) | |||
| IF and ISBLANK | Excel Worksheet Functions | |||
| ISBLANK() | Excel Worksheet Functions | |||
| ISBLANK | Excel Worksheet Functions | |||
| ISBLANK | Excel Programming | |||
![Stacy Haskins[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
