With a userForm this is a rather simple task for me, however, I am drawing a blank here. Simple task - Excel 2000.
- The listbox is embeded into Sheet1.
- Preferably would like to populate a listbox with code upon opening the workbook.
- Prefer not to have to set up another worksheet and build a named range to populate the list.
- Would prefer not to have a separate userform
- No subsequent manipulation needed.
- I would normally use a validated cell with a list however, would like to use the listbox_click event to trigger other routines.
- Listbox.AddItem would be used, just not sure where to use it.
Thank you in advance.
- The listbox is embeded into Sheet1.
- Preferably would like to populate a listbox with code upon opening the workbook.
- Prefer not to have to set up another worksheet and build a named range to populate the list.
- Would prefer not to have a separate userform
- No subsequent manipulation needed.
- I would normally use a validated cell with a list however, would like to use the listbox_click event to trigger other routines.
- Listbox.AddItem would be used, just not sure where to use it.
Thank you in advance.