how take data from refedit control

[witek84@gmail.com]

I have refedit control on userform and i don't know how take data from that
control(range). I want use that range after for exaple to comparision cells.
Thanks Pawel

[Gary Brown]

Assuming...
your form is named 'MyForm'
your RefEdit control is named 'RefEdit1'

The following line of code gets whatever is in the Refedit control...
MyForm.RefEdit1.Text

--
HTH,
Gary Brown
gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com
If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"witek84@gmail.com" wrote:

> I have refedit control on userform and i don't know how take data from that
> control(range). I want use that range after for exaple to comparision cells.
> Thanks Pawel