New to VBA/Macro and looking for guidance

Hi all,
I have only just started using Macro in order to make working life a bit less hassle.
i work for a company that occasionally are required to manufacture cables for specialist subsea equipment, usually through ROV systems.
I am trying to create a simple macro that would allow me to select the sensor and ROV type required, and when those conditions have been met allow me to access that wiring /schematic/hyperlink.

if anyone has any good websites or recommendations as to the best way to tackle this it would be highly appreciated.
thanks,

R.P

A simple (and I'll admit potentially complicated) way of doing this would be to have the Sensor and the ROV on validated lists.

Work out each possible combination and assign a value to it (in a control column). For each value put a vlookup in a control sheet to link to the wiring/schematic/hyperlink (so, for example, a wiring/schematic/hyperlink "Configuration Diagram 1") might satisfy multiple Sensor to ROV combinatins.

How many different Sensor types and ROV Types are there?

I don't think you need VBA to achieve what you're looking for.

I've mocked up a simple VLOOKUP to achieve the same. I'm sure there are much simpler ways of doing it, but it's a starter for 10.

Basically, the combination of Sensor against ROV gives you a value which is then connected by VLOOKUP to a link. I'll be honest, at the moment I'm struggling to get the external hyperlinks to work, but you should, at least be able to cut and past them.

Thats prefect MagicMan, thank you.
like i said, ive been previously im a complete novice when it comes to this sort of thing, and its difficult to find a guide specific
to what i required. but your example is the perfect start, really appreciate your help on this.

thanks

No problems. Believe, me, over many years I've had that much help from this group they've made me look brilliant at times.

It's nice to be able to give back when I can

If you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".

Thanks