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

[davegb]

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.

 

[Bob Phillips]

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]

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.