Hi guys (and girls),
Im having a slight but annoying issue on excel.
I have a form that will be used to log orders onto, the basic premise is that you select a product code from a drop down list and vlookup populates the description in the next cell. Im trying to add very basic validation using vba, so that when a product from the drop down list is selected an input box appears asking for the quantity and the puts that value in the corresponding quantity cell.
the problem is that with my current code, even if I specify only one cell as my range, when I change any of the dropdown lists the input box appears and changes the value in the first rows quantity box.
the current code is:
any help will be greatly appreciated thanks!
Bookmarks