VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1541941%22%20slang%3D%22en-US%22%3EVBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1541941%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542091%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20file.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542153%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542153%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20uploaded%20the%20file%20but%20didn't%20describe%20the%20issue%20you%20have%20with%20this%20file.%3C%2FP%3E%3CP%3EWould%20you%20please%20describe%20the%20issue%20you%20want%20help%20with%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543100%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3ENo%20it%20dont%20work%20when%20i%20scan%20somethimh%20it%20doesn't%26nbsp%3B%20add%20anythingin%20the%20list%20sheet%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543425%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543425%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wrote%20VBA%20only%20for%20laundry%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20try%20laundry%20sheet%20Row%20number%205.%20Type%20any%20value%20and%20see%20the%20laundry%20list%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543466%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543466%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22beikme_0-1595588145337.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207638iCCBA442FA261F010%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22beikme_0-1595588145337.png%22%20alt%3D%22beikme_0-1595588145337.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ei%20scanned%26nbsp%3B%20my%20slp%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20nothing%20come%20up%20in%20the%20list%20sheet%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543470%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543470%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20downloaded%20the%20file%20again%20and%20its%20works%20now%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20you%20do%20it%20for%20all%20the%20fields%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543534%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543614%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543614%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20vary%20much%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20will%20make%20my%20life%20so%20much%20easier%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20wish%20i%20would%20understand%20the%20code%20but%20i%20don't%20know%20how%20to%20write%20them%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20big%20thank%20you%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544062%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHI%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20more%20question%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20any%20why%20to%20make%20a%20print%20button%20so%20it%20would%20print%20the%20grade%20label%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22beikme_0-1595607408454.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207680i551D3DE0D022D423%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22beikme_0-1595607408454.png%22%20alt%3D%22beikme_0-1595607408454.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544069%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20make%20them%20print%20automatically%26nbsp%3B%20when%20we%20scan%20any%26nbsp%3B%20bare%20code%20in%20slp%20area%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544125%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544125%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESend%20sample%20file%20with%20barcode%20generated.%20And%20mention%20the%20area%20you%20want%20to%20print.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544142%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544142%22%20slang%3D%22en-US%22%3E%3CP%3Eso%20something%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20i%20scan%20something%20new%20in%20the%20are%20where%20is%2012345%20it%20would%20automatically%20print%20this%20label%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554746%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhether%20you%20want%20this%20for%20print%20purpose%20only%3C%2FP%3E%3CP%3Eand%3C%2FP%3E%3CP%3EIf%20you%20want%20the%20same%20format%20in%20sample%20excel%20sent%20by%20you%2C%20set%20this%20design%2Fformat%20in%20a%20sheet%20within%20the%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd%20the%20following%20lines%20(or)%20send%20the%20file%20i%20will%20add.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%20ActiveWindow.SelectedSheets.PrintOut%20Copies%3A%3D1%2C%20Collate%3A%3DTrue%2C%20IgnorePrintAreas%3A%3DFalse%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1739112%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1739112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53299%22%20target%3D%22_blank%22%3E%40Logaraj%20Sekar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20are%20you%20dooing%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuick%20question%20can%20you%20help%20me%20with%20this%26nbsp%3B%3C%2FP%3E%3CP%3Ei'm%20trying%20to%20print%20the%20label%20out%20every%20time%20the%20s%2Fn%20is%20updated%20but%20its%20not%20printing%26nbsp%3B%3C%2FP%3E%3CP%3Ei'm%20puling%20s%2Fn%20and%20slp%20frop%20diferent%20workbook%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1748239%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1748239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20working%20fine%20with%20me.%20Check%20your%20default%20printer.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor
15 Replies

@beikme 

 

Try this file. 

@beikme 

You uploaded the file but didn't describe the issue you have with this file.

Would you please describe the issue you want help with?

@Logaraj Sekar 

 

Hi

No it dont work when i scan somethimh it doesn't  add anythingin the list sheet 

@beikme 

 

I wrote VBA only for laundry sheet.

 

Just try laundry sheet Row number 5. Type any value and see the laundry list sheet.

@Logaraj Sekar 

Hi 

beikme_0-1595588145337.png

i scanned  my slp 

but nothing come up in the list sheet 

Hi 

I downloaded the file again and its works now 

can you do it for all the fields 

 

@Logaraj Sekar 

@Logaraj Sekar 

 

Thank you vary much 

this will make my life so much easier  

i wish i would understand the code but i don't know how to write them 

so big thank you  

@Logaraj Sekar 

HI 

One more question 

is there any why to make a print button so it would print the grade label 

beikme_0-1595607408454.png

 

@Logaraj Sekar 

 

or make them print automatically  when we scan any  bare code in slp area 

@beikme 

 

Send sample file with barcode generated. And mention the area you want to print.

so something like this 

when i scan something new in the are where is 12345 it would automatically print this label 

 

 

@Logaraj Sekar 

@beikme 

 

Whether you want this for print purpose only

and

If you want the same format in sample excel sent by you, set this design/format in a sheet within the workbook.

 

Add the following lines (or) send the file i will add.

 

 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False

 

@Logaraj Sekar 

 

Hi 

 

How are you dooing

 

Quick question can you help me with this 

i'm trying to print the label out every time the s/n is updated but its not printing 

i'm puling s/n and slp frop diferent workbook 

 

@beikme 

 

It is working fine with me. Check your default printer.