VBA

[beikme]

@Logaraj Sekar 

[#2]

@beikme 

Try this file. 

[#3]

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

[#4]

@Logaraj Sekar 

Hi

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

[#5]

@beikme 

I wrote VBA only for laundry sheet.

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

[#6]

@Logaraj Sekar 

Hi 

i scanned  my slp 

but nothing come up in the list sheet 

[#7]

Hi 

I downloaded the file again and its works now 

can you do it for all the fields 

@Logaraj Sekar 

[#8]

@beikme 

[#9]

@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  

[#10]

@Logaraj Sekar 

HI 

One more question 

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

[#11]

@Logaraj Sekar 

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

[#12]

@beikme 

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

[#13]

so something like this 

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

@Logaraj Sekar 

[#14]

@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

[#15]

@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 

[#16]

@beikme 

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