RefEdit control

[Dave]

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.

[keepITcool]

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.

[Jon Peltier]

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.

[Dave]

Thanks Jon, that was what i needed...

Dave

On Mon, 08 Aug 2005 23:42:52 -0400, Jon Peltier
<[email protected]> wrote:

>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.