Thread: Dialog Boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Dialog Boxes

Hi Edgar,

Try this

Check_Dlg.ListBoxes.Add 78, 100, 150, 16.5

change the position values to suit. To load it, use

Check_Dlg.Listboxes(1).AddItem "value1"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Edgar Thoemmes" wrote in message
...
Hi

I have the following code but I cannot seem to add a
ListBox to my DialogBox!

Sub Check_Emails()
Dim Check_Dlg As DialogSheet

Set CurrentSheet = ActiveSheet
Set Check_Dlg = ActiveWorkbook.DialogSheets.Add
Check_Dlg.ListBox.Add

End Sub

Also can any give me any tips on positioning the list box
on the dialogsheet?

TIA