If you want to read arrays, instead of MsgBox try
Application.InputBox which allows you to specify the type of
information to collect from the user.

Everything is the same as the standard InputBox command except there
is an extra argument  "Type" at the end. This argument allows lets you
pick the data type. Type:=64 is used for an array.