Treeview Issues in VBA/Excel 2010

Hi all

I've posted below a subroutine I've written that takes values from an Excel worksheet range and (should) add them to a treeview. There are three levels to the treeview, which the If statement sorts out for me depending on the cells next to the range in the Excel worksheet. Stepping through the code shows that the range is working fine, i.e. 'parentText' is being set to the what I'd expect, etc.

When I run the subroutine, however, the userform pops up without a populated treeview even though steppin through the code suggests to me that it has populated just fine.

Does anyone have ideas on what might be the cause of this? I'm fairly new to VBA and may well be doing something daft!

Thank you in advance for your time.

Alex

Please Login or Register  to view this content.

Looks like I was doing something stupid. I've added "Userform2." to the start of

Please Login or Register  to view this content.

on line 16 and it works. Thanks to all who read my post!