Hey friends,
*My knowledge of excel is not that great, I've managed to get some info here, and on other forums.
*I already have a ''zoeken'' button that opens a userform and asks me for a pc name (like MORLE640), and that returns if the pc is 'out of stock', 'in stock' or 'never been in stock'.
*Now what I would like is to add a userform that displays the overview of my intire stock (this overview is the one also located on the "STOCK"-sheet, cells U1:AI28), and highlights the PCyou entered on this overview, so that immediatly know where to find that PC.
*FYI: U1:AI28 contains the ASSET-name, and U48:AI75 contains the reffering PC-names.
Thanks for your time
http://www.sendspace.com/file/vn1glm
*My knowledge of excel is not that great, I've managed to get some info here, and on other forums.
*I already have a ''zoeken'' button that opens a userform and asks me for a pc name (like MORLE640), and that returns if the pc is 'out of stock', 'in stock' or 'never been in stock'.
*Now what I would like is to add a userform that displays the overview of my intire stock (this overview is the one also located on the "STOCK"-sheet, cells U1:AI28), and highlights the PCyou entered on this overview, so that immediatly know where to find that PC.
*FYI: U1:AI28 contains the ASSET-name, and U48:AI75 contains the reffering PC-names.
Thanks for your time
http://www.sendspace.com/file/vn1glm
