Thread: text or numeral
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lok Tak Cheong Lok Tak Cheong is offline
external usenet poster
 
Posts: 14
Default text or numeral

I am a newbie in excel VBA.
I attempt to set a condition to test cells property.
1. The cell have 5 characters
2. The first 2 characters are letters
3. The last 3 characters are numeral