Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a listbox to a spreadsheet
hi,
Does anyone have any code sample on how you would add/populate a listbox in a spreadsheet? thx -Philip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a listbox to a spreadsheet
Sub TesterAAA3()
Dim rng As Range Set rng = ActiveSheet.Range("B9:C15") With ActiveSheet.OLEObjects.Add( _ ClassType:="Forms.ListBox.1", _ Link:=False, _ DisplayAsIcon:=False, _ Left:=rng.Left, _ Top:=rng.Top, _ Width:=rng.Width, _ Height:=rng.Height) .ListFillRange = "Sheet3!A1:A20" End With End Sub -- Regards, Tom Ogilvy wrote in message om... hi, Does anyone have any code sample on how you would add/populate a listbox in a spreadsheet? thx -Philip |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a listbox to a spreadsheet
"Tom Ogilvy" wrote in message ...
Sub TesterAAA3() Dim rng As Range Set rng = ActiveSheet.Range("B9:C15") With ActiveSheet.OLEObjects.Add( _ ClassType:="Forms.ListBox.1", _ Link:=False, _ DisplayAsIcon:=False, _ Left:=rng.Left, _ Top:=rng.Top, _ Width:=rng.Width, _ Height:=rng.Height) .ListFillRange = "Sheet3!A1:A20" End With End Sub -- Regards, Tom Ogilvy wrote in message om... hi, Does anyone have any code sample on how you would add/populate a listbox in a spreadsheet? thx -Philip thanks that gave me a start |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding item in listbox | Excel Worksheet Functions | |||
Adding item in listbox | Excel Worksheet Functions | |||
Adding items to columns in a listbox | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Adding a row of data to a Listbox | Excel Programming |