S
Stuart
With much help I've a routine which will take a 'tagged'
workbook and sort it accordingly....that's to say, the
user works manually through the book, assigning 'tags'
(eg A, or Z, or A1, or A99 etc) to their relevent data.
They then save the book and run the routine on it.
During the routine, they are presented with a listbox
where col1 displays the sorted unique 'tags'. First time
through the book, col2 in the listbox is empty, and they
manually enter each 'real' value that the 'tag' represents
into col2.
I currently save the col1/col2 values to a new sheet in
the book (sheetname is "DataStore"), and for later runs
through that book, the user can opt to load col2 in the
listbox from "DataStore" rather than type in every same
value again. With each run, "DataStore" is updated
with any new col1/col2 entries.
The use of "DataStore" in the user's book is ideal to
let them review the library outside of any operating code
but its' existence at runtime means that I'm going to
have to work through every routine to explicitly exclude
that sheet from code........Or
As the user develops it, I see "DataStore" becoming a
single, common 'library' which they would use/update,
continually referring to it.
It would be common to workbooks across several
projects.
Thus during the routine to sort the tagged items they
would almost always default to it.
What I would like to do, is to
i) display "DataStore" alongside the tagged listbox, at the
appropriate point in the routine, so that user can see
the tags, against the 'library' items represented by
"DataStore"
ii) Maintain "DataStore" somewhere outside the user's
workbook, but where they can update it manually
without code.
For ii) I could place it in a sheet in the addin's workbook
and then a menu item for user to updata "DataStore"?
Sorry it's long-winded.
Any help/advice is much appreciated.
Regards.
workbook and sort it accordingly....that's to say, the
user works manually through the book, assigning 'tags'
(eg A, or Z, or A1, or A99 etc) to their relevent data.
They then save the book and run the routine on it.
During the routine, they are presented with a listbox
where col1 displays the sorted unique 'tags'. First time
through the book, col2 in the listbox is empty, and they
manually enter each 'real' value that the 'tag' represents
into col2.
I currently save the col1/col2 values to a new sheet in
the book (sheetname is "DataStore"), and for later runs
through that book, the user can opt to load col2 in the
listbox from "DataStore" rather than type in every same
value again. With each run, "DataStore" is updated
with any new col1/col2 entries.
The use of "DataStore" in the user's book is ideal to
let them review the library outside of any operating code
but its' existence at runtime means that I'm going to
have to work through every routine to explicitly exclude
that sheet from code........Or
As the user develops it, I see "DataStore" becoming a
single, common 'library' which they would use/update,
continually referring to it.
It would be common to workbooks across several
projects.
Thus during the routine to sort the tagged items they
would almost always default to it.
What I would like to do, is to
i) display "DataStore" alongside the tagged listbox, at the
appropriate point in the routine, so that user can see
the tags, against the 'library' items represented by
"DataStore"
ii) Maintain "DataStore" somewhere outside the user's
workbook, but where they can update it manually
without code.
For ii) I could place it in a sheet in the addin's workbook
and then a menu item for user to updata "DataStore"?
Sorry it's long-winded.
Any help/advice is much appreciated.
Regards.