Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Check For Numeric VBA

  1. #1
    Join Date
    29th December 2005
    Posts
    200

    Check For Numeric VBA

    in excel when im writing a vba macro is thier something that i specify to only find numerical, or only find alpha characters?

    what about in excel when im doing a odbc query?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,419

    Re: Numerical And Character Differential?

    I'm not sure what you are asking. In VBA the IsNumeric function can test whether something is a number or not. Is that what you want?
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

  3. #3
    Join Date
    29th December 2005
    Posts
    200

    Re: Numerical And Character Differential?

    yea thats what i was wondering. ill read up on the IsNumeric function then...ive been wondering how to do that

    thanks

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Check Column For Numeric Order
    By RAHCE in forum EXCEL HELP
    Replies: 2
    Last Post: December 30th, 2007, 19:55
  2. Check All Check Boxes With CheckBox
    By ajingham in forum EXCEL HELP
    Replies: 12
    Last Post: September 14th, 2007, 12:28
  3. Check If 1st x Characters are Numeric
    By BorneoHornbill in forum EXCEL HELP
    Replies: 4
    Last Post: August 10th, 2007, 16:22
  4. Check If First 5 Digits Of String Are Numeric
    By almecum in forum EXCEL HELP
    Replies: 9
    Last Post: May 23rd, 2007, 13:24
  5. Check Boxes not using check but x
    By tjolley in forum Excel and/or Word Help
    Replies: 2
    Last Post: July 13th, 2006, 23:43

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
  •  
porno