try dim myarray as variant

then

Myarray = Range("A6:D8").Value
should still work.

For large Userforms Arrays are a godsend.

Did you renamecyour textboxes?