Ok here it goes.
AddItem dosent work, nor dose list.
Kind regards
Code
-------------------
Dim myDoc As Worksheet
Dim list As Variant
list = ThisWorkbook.Sheets("Sheet1").Range("A2:A4").Value
Set myDoc = ThisWorkbook.Sheets("Sheet1")
myDoc.Shapes("ListBox1").list = list ' populate the listbox
myDoc.Shapes("ListBox1").ControlFormat.AddItem ("Whatever"
-------------------
Norman Jones Wrote:
Hi Rash,
Try posting your code which fails.
---
Regards,
Norman
"rash" wrote i
message
...
Hi, I want to fill a listbox thru VBA not connecting a range to it.
Every thing I tru (such as AddItem method) result i the error ms
"The
Object dosent support his method or property" Even if I copy th
Excel
Help Example, why is that?
Kind regards!
--
rash
------------------------------------------------------------------------
rash's Profile:
http://www.excelforum.com/member.php...o&userid=29765
View this thread
http://www.excelforum.com/showthread...hreadid=494825
--
ras
-----------------------------------------------------------------------
rash's Profile:
http://www.excelforum.com/member.php...fo&userid=2976
View this thread:
http://www.excelforum.com/showthread.php?threadid=49482