populating a listbox
You have a named range and change the named range before you call the user
form or you adjust the linked source and refresh the form.
--
Hope this helps
Martin Fishlock
"enyaw" wrote:
The listbox I have is populated by items on a worksheet. The items cannot be
moved in the worksheet because they are being used in a data validation. I
have code that links the listbox to the worksheet so when the item is
selected in the listox it is also selected on the worksheet. I need to be
able to reference only some of the list on the worksheet for the listbox.
e.g. I need say A6:A10 and A12:A15.
Any ideas?
|