View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stan Stan is offline
external usenet poster
 
Posts: 150
Default Is Indexing Possible in VBA/Excel?

Hello!

I'm having trouble with an Excel/VBA problem. I've created a spreadsheet which has a User Interface created in VBA.

I want the user to select 3 fields (on the form) which are unique each time. The fields a

Station
Year
Period

There can't be duplicate combinations of these values. I know how to do this in Access, but don't want to re-program everythin got operate there.

Can anyone suggest how this is done in Excel with VBA? I feel like I've been going round in circles, so any help would be greatly appreciated!

Thanks,
Stan