Compiler Error 'User defined type not defined'

Question

The following statement

Dim NewFrame As MSForms.Frame

is giving compile time error:

'User defined type not defined'.

Can anyone suggest how to fix this issue ?

fwiw, i found your answer inside 30 seconds by searching for **MSForms in 2016**. — , Jan 20 '18 at 06:34

score 1 · Answer 1 · answered Jan 20 '18 at 06:24

1

To access the methods, properties and members of a MSForms object, go to the VBE's Tools, References and put a check mark beside “Microsoft Forms 2.0 Object Library” (or similar for your version). This will link the FM20.DLL (or similar for your version) from your O/S's system32 folder.

answered Jan 20 '18 at 06:24

1

Yet if using forms it is automatically added ... – ACatInLove Jan 20 '18 at 06:34
Is that true for xl2016? i found some interesting information within the Q&A i marked as duplicate. – Jan 20 '18 at 06:37
Don't know. Will NEVER use 2016. – ACatInLove Jan 20 '18 at 06:59
Everytime I open workbook , I have to manually add FM20.dll. Is there any way by which I can permanently add the .dll ? – Tejas Kore Jan 21 '18 at 11:03

Compiler Error 'User defined type not defined'

1 Answers1