In article .com,
says...
Ex.

User form outputs a value; Using existing data, I want to assign the
form data (number 1-4) to a array, to get the value from a table(4x4).
User data will change so that is why I need an array var to be dynamic.


OK, hopefully someone else will pitch in. Simply restating the
original post and claiming it is an example doesn't really make it one.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions