I'm creating an excel tool that will manipulate data from the user and am
using VBA to develop the front end and back end.
One input will be a pivot table created from an Access database that
provides information for each hour of each day -- i.e. a 24 x 7 matrix.
Does this make sense?
Thanks.

"JLGWhiz" wrote:

Perhaps if you explained your objective, someone could offer an alternative
method. What you have described does not seem practical since after the
macro begins, copying and pasting becomes a little sticky. The key term
matrix implies a set of values that may interact with each other. Pasting a
matrix into a dialog box will only create a text entry without any
interactive capability other than as a value of the dialog box per se. So
think about it and see if you can explain what your end quality product
should be.

"JoLeigh" wrote:

I'd like to create a dialog box in which the user would input a matrix of
numbers. I'd like the user to be able to copy and paste this information
rather than type in each entry individually.

I'm a VBA Newbie and clueless.

Thanks much,
JoLeigh