Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Hi all
I am looking to use a listbox that look at the names in a workbook called client names, What I am looking to do is have the name of the individual worksheets appear in the list box so when the user select the name they need it opens that page automatically. Can this be done so when we have a new patient come into our care we can just add a new worksheet and the rest of the program automatically updates itself. Thanks again Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Private Sub Worksheet_Activate()
me.Listbox1.ListFillRange = "" me.Listbox1.clear for each sh in ThisWorkbook.Worksheets me.listbox1.AddItem sh.name Next End sub Put this in the sheet that will contain the listbox. -- Regards, Tom Ogilvy "Greg Brow" wrote in message ... Hi all I am looking to use a listbox that look at the names in a workbook called client names, What I am looking to do is have the name of the individual worksheets appear in the list box so when the user select the name they need it opens that page automatically. Can this be done so when we have a new patient come into our care we can just add a new worksheet and the rest of the program automatically updates itself. Thanks again Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Multicolumn Listbox and ordinary listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |