run micros / vba

[beikme]

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 ?

[#2]

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

[#3]

@NikolinoDE 

Hi 

so the idea is that when i scan slp in the are where is 123 

and s/n where is 456

on a laptop 

its live updates  to my main pc where i have this file open and have my  printer and print out the label 

i have the vba for printing the lable as soon as you scan s/n 

hope this helps 

[#4]

There you will find many examples that will help you.

Conditional Printing
https://excel.tips.net/T002372_Conditional_Printing.html

Please note that not everything and not all Sharepoint servers can be executed on VBA macros.
SharePoint capabilities
https://docs.microsoft.com/en-gb/sharepoint/dev/general-development/supported-and-unsupported-featur...

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)


I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)