View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wcc wcc is offline
external usenet poster
 
Posts: 3
Default does an item belong to an array?

Hello group,

Beginner here. Is there a function to check if an item belongs to an array?
For exmaple

dim arrStr(0 to 2) as string
dim str as string
arrStr(0) = "Jan"
arrStr(1) = "Feb"
arrStr(2) = "Mar"

str = InputBox("Type month: ")

How do I know if str is a member of arrStr? Do I have to loop through the array?
Thanks for your attention.

- wccppp