Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LIST BOX HELP
I'm just starting to use List Boxes, and Multi Select List Boxes.
I would like to do the following: I have a List Box with a Row Source that refers to Sheet inside the Wookbook. I would like to Click onto any one of the "Items" in the list Box and when I do, it takes me to that Sheet. The second example is to create a Print Selection, Here I would like to have the ability to have "Check Boxes" so that I can choose any number of boxes that I wish to Print. Each box is associated to a Print Range. -- MJM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LIST BOX HELP
set the listStyle property of the listbox to fmListStyleOption and set the multiselect property to fmMultiSelectMulti then worksheets(Userform1.Listbox1.Value).Select Dim rng as Range with Useform1.listbox2 for i = 0 to .listcount - 1 if .selected(i) then set rng = Range(.List(i)) rng.Printout end if Next End with -- Regards, Tom Ogilvy "MikeM" wrote: I'm just starting to use List Boxes, and Multi Select List Boxes. I would like to do the following: I have a List Box with a Row Source that refers to Sheet inside the Wookbook. I would like to Click onto any one of the "Items" in the list Box and when I do, it takes me to that Sheet. The second example is to create a Print Selection, Here I would like to have the ability to have "Check Boxes" so that I can choose any number of boxes that I wish to Print. Each box is associated to a Print Range. -- MJM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |