Forum Discussion

beikme's avatar
beikme
Brass Contributor
Sep 25, 2020

run micros / vba

Hi all

 

I'm after some help

I need to run print vba when cell is updated ( i have that vba )

but when i'm trying to share the file and open on the laptop so i can go around and scan bar code i have problem  whit opening the file i can only download copy , i need it to be live update so my other pc can print the labels as i'm going and updating cell 

any suggestions ?

Macros and VBA

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Sep 25, 2020

    beikme 

     

    Maybe this approach will help you in your project.

     

    Range("C6").FormulaR1C1 = "=PfadName(3)"

     

    If I may recommend you add a file (without sensitive data).
    Thus help yourself to get a quick answer and to be able to propose the best possible solution to all others who want to help you. Win-win for everyone.
    With your brief description, I can only guess whether that or this is.
    It is also an advantage if you name your operating system and Office version.

    Thank you for letting me suggest an approach / solution / help.
     

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Resources