This works great, and now I have a count. Thanks guys for all your help especially you
mdmackillop
Thanks.
This works great, and now I have a count. Thanks guys for all your help especially you
mdmackillop
Thanks.
Thanks Gsouza,
But Jindon has also added a new dimension to the solution, which I much appreciate.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I have a couple of questions about the solution posted by mdmackillop.
/1/ Can we assume the speed up is from keeping the data in memory and reassigning it to the list each time rather than reading it from a range somewhere in the workbook?
/2/ If you wanted to do this in a similar way but with ActiveX components on your worksheet, what would be major areas for rework?
Some methods are not easily substituted [for example replacing ComboBox with ActiveSheet.OLEObjects("ComboBox1")] produces the following illegal statement.
ActiveSheet.OLEObjects("ComboBox1").List = d.items
I am using Excel 2007 on XP. Thx.