+ Reply to Thread
Results 1 to 6 of 6

New to VBA/Macro and looking for guidance

  1. #1
    Registered User
    Join Date
    08-23-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2

    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

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,289

    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.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work 2013 Home 2019
    Posts
    360

    Re: New to VBA/Macro and looking for guidance

    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?

  4. #4
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work 2013 Home 2019
    Posts
    360

    Re: New to VBA/Macro and looking for guidance

    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.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-23-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2

    Re: New to VBA/Macro and looking for guidance

    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

  6. #6
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work 2013 Home 2019
    Posts
    360

    Re: New to VBA/Macro and looking for guidance

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Looking for guidance please
    By Potholes in forum The Water Cooler
    Replies: 15
    Last Post: 07-16-2019, 01:26 AM
  2. Guidance with Barcode Scanned Sales Recon Macro
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2017, 01:49 PM
  3. [SOLVED] Guidance reqd for filtering with nearby macro buttons
    By Tiger20 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 03:28 AM
  4. Macro array guidance
    By drobinson782001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2013, 11:34 PM
  5. Guidance please.
    By ariffinaldo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2013, 05:20 AM
  6. [SOLVED] Solver with Macro - need guidance for a small project
    By prashantha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2012, 05:11 PM
  7. Need some guidance
    By nfison in forum Excel General
    Replies: 5
    Last Post: 05-02-2007, 10:31 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1