Can a form be opened without opening up/displaying the workbook?

Hi, I'm new to using forms and would like to know if a form can be displayed without the user having to open up the whole workbook (ie. when the user double clicks the excel spreadsheet, only the form is displayed and the workbook is hidden). The reason I ask is that I want to create an application that can be used with a barcode scanner to search for and/or update products in a spreadsheet that I have already created but I dont want the user to have access to the workbook.
In the spreadsheet, there is one entry per item that gives an item description, a location and the item's barcode (I've attached a small example of the data within my spreadsheet). What I want to be able to do is scan an item's barcode and have excel search for and pull up the corresponding entries (description, barcode and location) and display them back to me within the form itself rather than opening up the worksheet and showing me the full line. Is this possible?
Once I've successfully achieved this, I plan to extend this to allow the user to update the line on the form (if a location changes for example) and have the new info updated in the worksheet.

Thanks guys, I'll give Thameem127's code a try and see how it goes. Ta.

Originally Posted by amhulli

Thanks guys, I'll give Thameem127's code a try and see how it goes. Ta.

Hai amhulli did u check my code.Let me know if your satisfied.

Thanks

Thameem

Thameem, I tried your code but couldnt make it work. I suspect it is because I am using it in the wrong location. In the VB window, I inserted your code into the "ThisWorkbook" Object. If not, could you please give me a hint as to where it needs to go?

Originally Posted by amhulli

Thameem, I tried your code but couldnt make it work. I suspect it is because I am using it in the wrong location. In the VB window, I inserted your code into the "ThisWorkbook" Object. If not, could you please give me a hint as to where it needs to go?

Go to VBA editor ----> insert module ----->copy my code--->-save and close your workbook-----> open again now u can see userform1 automatically

populate.

Thameem, The form opens automatically but the spreadsheet also opens maximised rather than minimised. Any thoughts?

Originally Posted by thameem127

Yes.There is one way.Try this code

Please Login or Register  to view this content.

I just moved code from line three t0 line two

Thameem, all sorted - thanks for your help.

Your welcome.Don't forget to click Star button.

Thanks

Thameem