+ Reply to Thread
Results 1 to 4 of 4

Value Test (Excel 14/2010) [VBA Only]

  1. #1
    Forum Contributor
    Join Date
    03-22-2012
    Location
    OR, USA
    MS-Off Ver
    Excel 14/2010
    Posts
    273

    Value Test (Excel 14/2010) [VBA Only]

    I have been unable to use the following code in the matter for which it is designed. A user will input a 5 character string. If the first character is a letter then the input is a HCPCS code. If the first character is a letter then it is a CPT Code. This determination is necessary for the next step which is a Vlookup based on different arrays dependent on the type of code it is. Any help as to what the problem is, how to correct it... would be much appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,186

    Re: Value Test (Excel 14/2010) [VBA Only]

    Hi, lloydgodin,

    maybe omit Val for the test:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Value Test (Excel 14/2010) [VBA Only]

    I'd also suggest you use
    Please Login or Register  to view this content.
    rather than
    Please Login or Register  to view this content.
    since IsNumeric returns a boolean and not a string
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Contributor
    Join Date
    03-22-2012
    Location
    OR, USA
    MS-Off Ver
    Excel 14/2010
    Posts
    273

    Re: Value Test (Excel 14/2010) [VBA Only]

    Had already removed the quotes. And removing Val worked out just perfectly. Thank you gents.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1