To refedit, or not to refedit, that is the question.
 

I'm writing a macro that requires the user to input 2 items. The first
is just a simple choice between 3 options. The second is to identify
where the data they want manipulated is located on the sheet. I've
looked into doing it all in a single userform using a refedit control,
but I'm finding lots of very negative information about refedit. Would
I be better off just using 2 separate input boxes, the second one type
8, rather than a single userform with a refedit control? Is it really
that bad? This is a very simple application, no frames, no need to
setfocus or anything like that. But I really don't want to send out a
macro to all my users that will be locking up on them. What's the
verdict from the experts here?

Thanks in advance.

To refedit, or not to refedit, that is the question.
 

I use RefEdit regularly, just don't put one inside a frame.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"davegb" wrote in message
oups.com...
I'm writing a macro that requires the user to input 2 items. The first
is just a simple choice between 3 options. The second is to identify
where the data they want manipulated is located on the sheet. I've
looked into doing it all in a single userform using a refedit control,
but I'm finding lots of very negative information about refedit. Would
I be better off just using 2 separate input boxes, the second one type
8, rather than a single userform with a refedit control? Is it really
that bad? This is a very simple application, no frames, no need to
setfocus or anything like that. But I really don't want to send out a
macro to all my users that will be locking up on them. What's the
verdict from the experts here?

Thanks in advance.

To refedit, or not to refedit, that is the question.
 

Bob Phillips wrote:
I use RefEdit regularly, just don't put one inside a frame.

--

HTH

Bob Phillips


Thanks, Bob, I think I'll take the plunge and try it.

(replace xxxx in the email address with gmail if mailing direct)

"davegb" wrote in message
oups.com...
I'm writing a macro that requires the user to input 2 items. The first
is just a simple choice between 3 options. The second is to identify
where the data they want manipulated is located on the sheet. I've
looked into doing it all in a single userform using a refedit control,
but I'm finding lots of very negative information about refedit. Would
I be better off just using 2 separate input boxes, the second one type
8, rather than a single userform with a refedit control? Is it really
that bad? This is a very simple application, no frames, no need to
setfocus or anything like that. But I really don't want to send out a
macro to all my users that will be locking up on them. What's the
verdict from the experts here?

Thanks in advance.