Re: Is Alaphabetic

Tech-Archive recommends: Fix windows errors by optimizing your registry

My bad - poor reading of the Help...

Tim

"Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
news:%23tk76t8HGHA.3700@xxxxxxxxxxxxxxxxxxxxxxx
> Function IsAlpha(s As String)
> IsAlpha = (UCase(s) Like "[A-Z]")
> End Function
>
> Think it would be a little more complex than that:
>
> ? isalpha("abc")
> False
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Tim Williams" <saxifrax at pacbell dot net> wrote in message
> news:u5XGaF8HGHA.2948@xxxxxxxxxxxxxxxxxxxxxxx
>> how about
>>
>> Function IsAlpha(s as string)
>> IsAlpha = (ucase(s) like [A-Z])
>> end function
>>
>> ?
>> Tim
>>
>> "C. Roenbaugh" <croenbaugh@xxxxxxxxx> wrote in message
>> news:1137979914.209078.134700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> >I need a function in VBA like "isNumeric" that checks if a string only
>> > contains alaphabetic characters. Would love some help.
>> >
>> > Thanks
>> >
>> > CR
>> >
>>
>>
>
>


.

Quantcast