I was wondering if it would be possible for me to work a vLookup function into my VBA code for my command button to where after it pastes the appropriate information in the cell it performs a vLookup to find the price of said item and adds it into a cell across from the selection.
To try and explain better I have a listbox in a userform that contains three columns. The Name,Description, and Price respectively (However I can only seem to get it to paste on selection, so a work around of that would be very welcome instead) When I click the button it takes the Description selection of the CMD Box and puts it in the active cell (I need to be able to place it active cell due to the unpredictable placement needs) however I also need to have the price across the page from it so I was wondering if there would be a way to incorporate vlookup so that it would figure the price that way or if I should just scrap this idea and rethink of how to go about it.
Bookmarks