VBA Transfer Macro

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Dear Forum,


    I currently have the below code in my workbook that transfers data from a data sheet into individual employee sheets. This works fine so far but I would like to ask if anyone could please assist me in a few adjustments?


    What I am trying to achieve with the amendments would be:


    1. Is it possible when the user hits the Submit button on the UserForm1 that the sheets automatically update? reason I ask is that now it works great but I need to run the code each time new data is added, and this then means duplicate entries, which would also lead me to ask;
    2. if 1. is possible is there a way to avoid duplicate entries? however it is possible the same ticket number a. could appear for more than 1 user and b. could appear more than once for the same user




    Kind Regards


    Bob

  • Re: VBA Transfer Macro


    Not sure I follow... Why not just call the transfer procedure as part of the Submit button?


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: VBA Transfer Macro


    Hi Ger,


    Can you advise me please? I'm not so great with VBA (yet). I already have the below code for the Submit Buttom (CommandButton1), can you advise me where / how I add the transfer procedure?


  • Re: VBA Transfer Macro


    Just put this call to the transfer macro right before the end of your sub...


    Code
    call transfer
    end sub


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: VBA Transfer Macro


    Note - you might also have to change the definition of transfer


    from

    Code
    sub transfer()


    to

    Code
    public sub transfer()


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!