Instead of following Excel help to refer to my listfillrange as below:

worksheets(i).shapes(i).controlformat.listfillrang e = "R1C1"

which kept giving me the "object not defined" error.

I found out this will work:

worksheets(i).[name of my list box].listfillrange = "R1C1"

Sometimes I just don't understand how the object/class/property work
in VBA for Excel.

spacecitygu

--
spacecitygu
-----------------------------------------------------------------------
spacecityguy's Profile: http://www.excelforum.com/member.php...fo&userid=1106
View this thread: http://www.excelforum.com/showthread.php?threadid=31878