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

**lloydgodin** · 12-31-2012, 10:15 AM

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.

**HaHoBe** · 12-31-2012, 10:31 AM

Hi, lloydgodin,

maybe omit Val for the test:

Please Login or Register  to view this content.

Ciao,
Holger

**JosephP** · 12-31-2012, 10:52 AM

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

**lloydgodin** · 12-31-2012, 11:41 AM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions