striveforexcelence
Technical User
I tried to post this in the vba forum but it is down today apparently. Hoping someone in this forum can help.
I have a userform that has a listbox which draws the items in the list from sheet"(products").range("A1:B15") The items in column A are products and the information in column b are the corresponding unti costs.
I have tried to research this on the net and on other forum discussions but there seems to be no real direction with this. How do I go about using code to make the user's choice place onto worksheet"inventory" product = column a and unit cost = column b. After I have this I will go on to have it find the first available row but the main thing is I need the choice to go to column a and b regardless of where the cursor is. At present it places the choice wherever the cursor was last left positioned.
Any help or any direction for researching this would be greatly appreciated. I looked on microsoft and a couple of other articles but they seem to concentrate on creating the form and explaining controls rather than how to code the listbox to work.
Thank you very much!
I have a userform that has a listbox which draws the items in the list from sheet"(products").range("A1:B15") The items in column A are products and the information in column b are the corresponding unti costs.
I have tried to research this on the net and on other forum discussions but there seems to be no real direction with this. How do I go about using code to make the user's choice place onto worksheet"inventory" product = column a and unit cost = column b. After I have this I will go on to have it find the first available row but the main thing is I need the choice to go to column a and b regardless of where the cursor is. At present it places the choice wherever the cursor was last left positioned.
Any help or any direction for researching this would be greatly appreciated. I looked on microsoft and a couple of other articles but they seem to concentrate on creating the form and explaining controls rather than how to code the listbox to work.
Thank you very much!