Jason_VBANew
New Member
- Joined
- Aug 31, 2014
- Messages
- 1
Hi,
I am new to using VBA in excel and need help setting up a combobox used on a form. I have a combo box that is set up to be able to select a product and then I would like to limit the number of selections in the next combobox dependant on the first selection.
For example:
i) If I select product 1 from combobox1; then only batch numbers 0123, 4567, 8910 are available for selection in combobox2.
ii) If I select product 2 from combobox1; then only batch numbers 1098, 7654, 3210 are available for selection in combobox2.
If possible, I would then also like the next field (textbox1) be automatically populated with an expiry date based on the selection in combox2 using a vlookup function. The expiry dates are on another sheet within the workbook (sheet2).
Thanks,
Jason_VBANew
I am new to using VBA in excel and need help setting up a combobox used on a form. I have a combo box that is set up to be able to select a product and then I would like to limit the number of selections in the next combobox dependant on the first selection.
For example:
i) If I select product 1 from combobox1; then only batch numbers 0123, 4567, 8910 are available for selection in combobox2.
ii) If I select product 2 from combobox1; then only batch numbers 1098, 7654, 3210 are available for selection in combobox2.
If possible, I would then also like the next field (textbox1) be automatically populated with an expiry date based on the selection in combox2 using a vlookup function. The expiry dates are on another sheet within the workbook (sheet2).
Thanks,
Jason_VBANew