Solved

Excel VBA Syntax - ISNUMERIC versus ISTEXT oddity?

Posted on 2013-12-09
1
2,022 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 500 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

630 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