Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox multiselect to control original cells
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 :P I cannot manipulate the physical layout of the sheet itself as other macro's are located on these sheets. many thanks Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox multiselect to control original cells
If the range is contiguous, maybe you could just loop through the listbox's
list--and then offset from the first cell of the range. dim FirstCell as range 'set firstcell = to the firstcell in the range With Me.ListBox1 For lCtr = 0 To .ListCount - 1 If .Selected(lCtr) Then msgbox firstcell.offset(lctr,0).value End If Next lCtr End With ArmsteR wrote: 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 :P I cannot manipulate the physical layout of the sheet itself as other macro's are located on these sheets. many thanks Dave -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bug in multiselect listbox? | Excel Programming | |||
Multiselect Listbox | Excel Programming | |||
Multiselect Listbox | Excel Programming | |||
multiselect on a listbox from Control toolbox | Excel Programming | |||
multiselect listbox | Excel Programming |