|
|
#1
20-02-2011, 08:26
|
|||
|
|||
Condition of entry number(s) in the code?
Whether it is possible to write the condition:
If No is not a number (positive or negative) Then Exit Sub. 
|
|
#2
20-02-2011, 08:35
|
||||
|
||||
|
Hi.
Like this: Code:
Sub testIt()
Dim n
n = 5
'n = "Something else"
If Not IsNumeric(n) Then Exit Sub
MsgBox "N is a number!"
End Sub
|
|
#3
20-02-2011, 08:46
|
|||
|
|||
|
Thx for fast reply.
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| number spot colors | robert | CorelDRAW/Corel DESIGNER VBA | 2 | 10-11-2008 02:05 |
| Number of weeks | Geir | Calendar Wizard | 1 | 09-11-2006 22:10 |
| HELP Serial Number | Denise | Calendar Wizard | 0 | 20-08-2005 14:26 |
| "Unexpected condition" error message (with code) | s_federici | CorelDRAW/Corel DESIGNER VBA | 10 | 10-07-2003 21:46 |
| Condition #1002 -Listman- 0737 (Wierd memory leaks issues) | wbochar | CorelDRAW/Corel DESIGNER VBA | 6 | 15-05-2003 16:48 |
Linear Mode
