Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2019, 04:08 PM
Guessed's Avatar
Guessed Guessed is online now User-Defined Type is Not Defined Windows 10 User-Defined Type is Not Defined Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

In the VBA Editor while looking at the macro...

Go to Tools > References. This opens the References dialog
In the References dialog, find Microsoft Forms 2.0 Object Library and put a tick beside it and press OK

If the References dialog doesn't show Microsoft Forms x.x Object Library, click the Browse... button and an Add Reference dialog appears (with the System32 folder open).
Find the FM20.dll file and select it and click the Open button. This returns you to the References dialog and you should now see the object library in the list and it will be ticked.
Click the OK button to close the References dialog.
Go to Debug > Compile Project and you should now see that line in your code is now accepted



IF any of the menu commands are greyed out, click the Reset (square) button on the toolbar to stop the macro - when a macro is paused, some of the menu commands are not available.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 04-25-2019, 06:31 AM
StephenRay StephenRay is offline User-Defined Type is Not Defined Windows 7 64bit User-Defined Type is Not Defined Office 2010 64bit
Advanced Beginner
User-Defined Type is Not Defined
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

Guessed,
Thank you for your reply, I will take some time with it soon. I am working 12 hour days here, so I don't have a lot of time. Yesterday they said some of us should come in on Sunday too!
I am all by myself with MACROs but they have several of us trying to learn PowerShell to use with Active Directory.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
User-Defined Type is Not Defined FileSystemObject Compile Error: User-Defined Type Not Defined gsrikanth Excel Programming 2 03-28-2022 06:32 AM
User-Defined Type is Not Defined Application Defined or Object defined error bennyamy Excel Programming 4 03-23-2017 11:42 AM
User-Defined Type is Not Defined User-defined Type not Defined VBA Issue OTPM Project 3 01-02-2014 01:47 PM
User-Defined Type is Not Defined Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err tinfanide Excel Programming 2 06-09-2012 10:19 AM
User-Defined Type is Not Defined Application-defined or Object-defined error Manit Excel Programming 4 12-08-2011 07:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft