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
|