A
ArmsteR
Is it possible to get the multiselection the users make in the listbox
correlate directly to the original cells the rows pertain to?
the reason is I need to be able to get the users to multi select the
cells they want to print and then send print commands to the documents
ancd drawings located in their hyperlinks. So if there was some way to
pull the Cells selections then I could work with this indefinately.
I''m unsure whether this is feasable, I was thinking of putting the
multiselect results into an array using the text values then doing a
vlookup or something, but the original drawing register sheet doesn't
have unique items just unique hyperlinks I cannot manipulate the
physical layout of the sheet itself as other macro's are located on
these sheets.
many thanks
Dave
correlate directly to the original cells the rows pertain to?
the reason is I need to be able to get the users to multi select the
cells they want to print and then send print commands to the documents
ancd drawings located in their hyperlinks. So if there was some way to
pull the Cells selections then I could work with this indefinately.
I''m unsure whether this is feasable, I was thinking of putting the
multiselect results into an array using the text values then doing a
vlookup or something, but the original drawing register sheet doesn't
have unique items just unique hyperlinks I cannot manipulate the
physical layout of the sheet itself as other macro's are located on
these sheets.
many thanks
Dave