Sourcing RefEdit events

[mikerickson]

If I want a variable to source events from a userform's textbox, I would use

 Public myTextBox as msForms.TextBox

.

What class would I use to source events from a RefEdit control?

There is no msForms.RefEdit class.

Thanks.

(Yes, I know they are buggy as all get out. )

 

[MarcelBeug]

This works with me:

Sub testRefEdit()

Dim myRefEdit As RefEdit.RefEdit

Set myRefEdit = UserForm1.RefEdit1


End Sub

 

[mikerickson]

I get a "User defined type not defined" error.
I guess my Mac (Excel 2011) doesn't have the RefEdit library. (2004 did).

 

[MarcelBeug]

My Windows 8.1 laptop has, i.e. once I create a userform with a RefEdit control, I have RefEdit in my Object Browser, refering to:
C:\Program Files\Microsoft Office 15\Root\Office15\REFEDIT.DLL

 

[mikerickson]

Does that source events?
If you put Public WithEvents myRE as RefEdit.RefEdit in a Class Module, does the drop down give you the option for myRE events?

 

[MarcelBeug]

Does that source events?
If you put Public WithEvents myRE as RefEdit.RefEdit in a Class Module, does the drop down give you the option for myRE events?

It does, but first after adding the reference "RefEdit Control", either via Tools - References or by creating a form with a RefEdit control.