Solved

Excel VBA Syntax - ISNUMERIC versus ISTEXT oddity?

Posted on 2013-12-09
1
1,624 Views
Last Modified: 2013-12-13
Why do I need to prefix the test with "application." for "istext" but I don't need to add "application." for "isnumeric"?


If Application.IsText(ActiveCell.Value) Then
        MsgBox "yes"
End If
------------------------------------------------------------
If IsNumeric(ActiveCell.Value) Then
    MsgBox "yes"
End If
0
Comment
Question by:brothertruffle880
1 Comment
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

Because IsText is a WorksheetFunction and IsNumeric a VBA Function
EDIT
 IsNumeric  is Member of VBA.Information
and
IsText  is Member of Excel.WorksheetFunction

Therefore Application.isText


Regards
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now