Pass Userform values to UF variables

I have read the previous posts (mikerickson) and tried to implement them without success.
See http://www.excelforum.com/excel-prog...-into-vba.html

Userform frmData obtains cell ranges in RefEdits and two doubles in text boxes.

Please Login or Register  to view this content.

The result is Error 91 - object not set or no With.

I see the Me object in Locals. It includes the RefEdit and Text objects. These seem to have values in three baleces: BoundValue, Value and Text. I have tried all three without success.
I have tried both explicit Me and frmData in the object names and a With End With statement using Me and frmData, both with no success.

I am not sure of the problem.
Error 91 implies that the object is not being referenced, but Me is there. Explicit frmData makes no difference.
Substituting BoundValue, Value and Text makes no difference.

I appreciate your Expert help - this is my first experience with Userforms having previously dealt only with User Functions.

I'm guessing here.

If you Dim Result() as an Array, I believe you have to refer to it as an array at all times.

Result() = test(.....)

Try

Please Login or Register  to view this content.

In the original message click EDIT>GO ADVANCED>PREFIX

I'm glad my code worked for you.