Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel VBA Syntax - ISNUMERIC versus ISTEXT oddity?

Posted on 2013-12-09
1
Medium Priority
?
2,575 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 55

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39705794
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

608 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