+ Reply to Thread
Results 1 to 13 of 13

Validating a cell contains an integer

Hybrid View

  1. 11-21-2015, 11:52 PM #1
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Validating a cell contains an integer

    Try vbdouble(not tested)
    If VarType(Range("Quantity1")) = vbDouble Then
    Reply With QuoteRegister To Reply
  2. 11-21-2015, 11:56 PM #2
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Validating a cell contains an integer

    Quote Originally Posted by jindon View Post
    Try vbdouble(not tested)
    If VarType(Range("Quantity1")) = vbDouble Then
    How does that test for an integer?

    Here's a thread you were involved in back in 2004.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Validating user name in cell
    By momoknz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2013, 11:25 PM
  2. Trying to round a decimals that are near an integer to an alternate integer?
    By jxales in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2013, 03:30 PM
  3. Validating a cell value
    By tonyromero in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2013, 04:50 AM
  4. Referencing a non-integer or generating a consecutive integer
    By jocund.ky in forum Excel General
    Replies: 3
    Last Post: 10-27-2011, 05:20 PM
  5. Validating a cell
    By m.cain in forum Excel General
    Replies: 5
    Last Post: 07-07-2011, 03:51 PM
  6. Count the number of occurrences of an integer withing a larger integer
    By nnktran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2010, 01:04 PM
  7. Validating a Cell
    By leelu_uma in forum Excel General
    Replies: 2
    Last Post: 11-05-2008, 06:47 AM
  8. [SOLVED] Validating certain cell
    By Kasey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-17-2006, 10:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1