Display Generated Barcode Picture

Hi, I'm a totally new to Excel and currently I'm using Excel 2010 to create Search Form with a combo box which allow me to search any value that I want from the list and to display barcode picture that I used barcode generator online to generate. On the Datasheet I have Material and correspondence Generated Barcode Picture side by side in Colum A1 and A2 respectively. What I need is whenever I type Material's Name in combo box and click a button call "get barcode", I should have the barcode picture display somewhere in the Form and I also want to add a button to copy the barcode to paste somewhere e.g to paste onto sticker to create Barcode Label. Thank You For Much For Your Help. May God Bless You. Thanks Again In Advance.

To generat barcodes in Excel spreadsheets, I think a barcode add-in for Excel can solve your problem easily.

Yes, Actually I can use the add in Barcode but my Manager want a barcode with the Text showing Below the barcode for example in Generator if I type Aluminium I will get a generated barcode as weel as the text "Aluminium" below the barcode. He wants to see the text in every barcode so that the users can still varify even the barcode scanner is not working Actually I'm just an Engineering Student who is having industiral attachment for 6 weeks . Everything is new to me working in Logestic Area.. Now I already have the search page with a combo box... I just need to know how to display barcode picture in the Form I know which is very tidious but i have no choice Thank You So Much For Your Advice.

You are welcome. Acctually, I encountered the problems like yours a few weeks ago and I find a good solution on that website. You can download a free trial on it. additionally, the barcodes created by that add-in can display the text under the barcode images. Hope you can get over your problem quickly

Thank You So Much for ur Help and Kindness... I will let u know again whether I can slove the problem. Thanks Again..

No problem. Good luck.

Hi! I already tired the link u gave me but those add-in barcode are in picture format so I can't be able to link to a cell value that I want. I think VBA to link the cell value and the picture but I don't undestand VBA I attach my excel work sheet that i'm working on so that may be u can give me some idea... According to the program when u selecte the Material from drop box and click get barcode... the barcode picture should show below the barcode field on the Form thank you so much

Ok, I will see what can do for you. contact you later

Hi, Skyi. I have downloaded adn seen the attached files you gave to me. The barcode add-in for Excel provided by keepautomation.com supports to link cell value to barcode images. You can click any specific barcodes web page on the left, like Code 39 for Excel, to read the subtile "How to Link Code 39 to Cell Content in Excel". By the way, I see there are different types of data matierials in your file. I think you need to find suitable barcode types for these materials. Hope I can help you. If you have any more questions, just tell me. I will try my best to help you.

As far as I know, there exists a barcode add-in for EXCEL 2007. But I am not sure whether it works for 2010 version. Maybe you just have a try.

I have used this barcode add-in for Excel. It works for Excel 2010.

there are many ways to do that. If you wanna save these complicated steps and find a easy way, you can google barcode scanner and you will find many useful tools, or google how to read barcode in c# to get instructive articles. Good luck I think some imaging sdk programmes can enable to quickly scan barcodes. i have use imaging sdkr which can original layouts hyperlinks, Images and tables retained in word ,text, image, Epub, html.but i forgot download the wedsite ,go to google. By the way , pay attention to your system platform, select the suitable one . I use a barcode scanner driver found on the internet . Install it and it becomes a selectable option.Then you can scan barcodes in many formats in any program at all, including Adobe Acrobat . Just open the sdk, select barcode, and choice a form you want, then you can scan barcode in c#, vb, sdp ,etc ,the task will be finished in several seconds. if you haven't found a good choice , you can have a try. best wishes.

Originally Posted by danny rough

there are many ways to do that. If you wanna save these complicated steps and find a easy way, you can google barcode scanner and you will find many useful tools, or google how to read barcode in c# to get instructive articles. Good luck I think some imaging sdk programmes can enable to quickly scan barcodes. i have use imaging sdkr which can original layouts hyperlinks, Images and tables retained in word ,text, image, Epub, html.but i forgot download the wedsite ,go to google. By the way , pay attention to your system platform, select the suitable one . I use a barcode scanner driver found on the internet . Install it and it becomes a selectable option.Then you can scan barcodes in many formats in any program at all, including Adobe Acrobat . Just open the sdk, select barcode, and choice a form you want, then you can scan barcode in c#, vb, sdp ,etc ,the task will be finished in several seconds. if you haven't found a good choice , you can have a try. best wishes.

Thanks for your info. But I used to work with barcode in PDF documents,it is my first time to work with barcode in Excel. I hope I can success. I will try your method later.



Best regards,
Arron