Hello All,

Could anyone provide some help on adding a RefEdit control to a
userform programmatically. It's a breeze with the basic controls, but
I can't find much info on the RefEdit control. Do all I need is the
"progid"?

Thanks very much.

If you drag a refedit on your form
the reference s/b added to the project.

HOWEVER:
the refedit is a very buggy control.
save yourself lot's of hassle and avoid where possible
replace with a application.inputbox(Type:8)


RefEdit:
Focus problems in frames/multipage
(can be solved but requires extensive code)

Cannot be used on modeless forms.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Dave wrote :

Hello All,

Could anyone provide some help on adding a RefEdit control to a
userform programmatically. It's a breeze with the basic controls, but
I can't find much info on the RefEdit control. Do all I need is the
"progid"?

Thanks very much.

Dave -

The RefEdit isn't a member of the Forms library. In this thread, post 5,
I show how to add RefEdit controls programmatically to an open form:

http://groups.google.com/group/micro...f0de6a884c0708

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Dave wrote:
Hello All,

Could anyone provide some help on adding a RefEdit control to a
userform programmatically. It's a breeze with the basic controls, but
I can't find much info on the RefEdit control. Do all I need is the
"progid"?

Thanks very much.