I'm using a combobox from forms. I want to populate the box from VBA as the values do not currently exist within the worksheet and I wanted to keep the worksheet clean. Obviously open to other suggestions.
Also, how do I refer to the combobox value, when using a combobox on a form, it appears to be pretty straightforward, i.e. combobox1.text but having no joy with a combobox directly on the sheet.