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.
MS Office 365 Version 2304 (Build 16307.20006) Win 11 Home 64 Bit
Re: New to VBA/Macro and looking for guidance
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
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.
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".