Excel 2010 :: User-Defined Type Not Defined Compile Error When Creating PowerPoint Using VBA

Jul 29, 2014

I am using Microsoft Excel 2010 and Microsoft VBA 7.0 on my system. I would like to eventually create a PowerPoint and insert charts generated in the Excel workbook. In the meantime, I cannot get the basic PowerPoint created.

The line in red is highlighted blue when the compile error "User-defined type not defined" message box appears.

Public Sub TryAgain() Dim myPowerPoint As PowerPoint.Application
' do nothing for now
'End Sub

I have set the references such that Microsoft Project 14.0 Object Library is indeed checked. The Excel file only contains this code in a module. All sheets are blank. Nothing else is written yet.

View 1 Replies


Excel 2003 :: Stuck On User-defined Type Not Defined Error?

Oct 9, 2012

Trying to convert an Excel 2003 macro to work in Excel 2007.

The problem line is

Dim MyDataObject As DataObject

I suspect the problem is a Missing Reference, but I cannot figure out which one. I have the same ones (in 2007) as 2003 except for one which is not showing

Microsoft Forms 2.0 Object Library

Is this the one it needs? It is called something else in 2007?

The ones I do have ticked are

Visual Basic For Applications
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.8 Library
Microsoft Scripting Runtime
Microsoft XML v2.6

View 8 Replies View Related

Excel 2010 :: Win 8 User Defined Type Not Defined?

May 5, 2013

Base 64 Encoding.

Dim objXML As MSXML2.DOMDocument
Dim objNode As MSXML2.IXMLDOMElement

Are causing the User Defined error, but the same workbook is OK in XP and Win 7.

VB6: Free, Easy and Quick Base64 Encoding and Decoding in Visual Basic [a NonHostile article]

Says you need a reference to Microsoft XML, v2.6 (or later) and the Win8/2010 workbook does have one for Microsoft XML, v6.0

View 1 Replies View Related

User-defined Type Not Defined Error

Jun 27, 2008

When I try to complile my VBA project, I get the following error "User-defined type not defined" but the compiler doesn't point to any line.

I remember what I did last was to rename a form and a Module, but I replaced their old names in all my code with the new ones ... Does this have anything to do with the error I am getting ?

View 9 Replies View Related

File System Object: User-Defined Type Not Defined

Nov 28, 2006

I had a working subroutine which I moved to another workbook (rather than linking to it and having both workbooks open at the same time).

Now I get "user-defined type not defined" when it runs. Here is the beginning of the
Global oApp As Object

Sub UpdateForecasts()
Call Update1
Call Update2
End Sub

Sub Update1()
Dim dPath As String
Dim dDest As String
Dim dCondition As String
Dim dName As String
Dim FSO As New FileSystemObject

View 9 Replies View Related

User-defined Type Not Defined - Command Bar Control

Mar 4, 2010

I am trying to capture with Worksheet Change a command bar action like paste but I am getting an error :

“User-Defined type not defined”

Do I need a library of sort in References ??

Public Sub Right_Click()

Dim oControl As CommandBarControl

For Each oControl In CommandBars("Cell").Controls
Debug.Print oControl.Caption
If oControl.Caption = "&Paste" Then
oControl.OnAction = "MyPaste"
End If
Next oControl

End Sub

View 9 Replies View Related

Application Defined Or Object Defined Error When Creating A Pivot Table

Oct 1, 2009

I keep running into this error when I try to create a pivot table.

The debugger highlights the following line:

View 4 Replies View Related

User Defined Type Not Defined

Dec 11, 2012

Which I am trying to modify to fit my needs:


Sub Test()
Const cURL = "Website Here" 'Enter the web address here
Const cUsername = "XXXXXX" 'Enter your user name here
Const cPassword = "XXXXXX" 'Enter your Password here

Dim IE As InternetExplorer
Dim doc As HTMLDocument
Dim LoginForm As HTMLFormElement

[Code] .......

I get the error User Defined type not defined on line:

Dim IE As InternetExplorer

Do I need to use references? Is there a quick fix for this?

I have code that works for a particular website but I am having trouble making it work for others. This code seems more flexible than the other code:

Option Explicit

Public Sub Press_Button()

'make sure you add references to Microsoft Internet Controls (shdocvw.dll) and
'Microsoft HTML object Library.
'Code will NOT run otherwise.

[Code] ........

My end goal is to log on to several websites and pull data out of tables on the websites back into excel so that I can have a one stop shop instead of logging into many websites manually.

View 5 Replies View Related

User Defined Type Not Defined

Aug 28, 2008

This code works fine when I use it, but not when a co-worker uses it on his PC. The code and VBA references are the same. He gets the "User-Defined Type not defined" error. I'm wondering if there is an Outlook setting that may blow this up.

the code was working on his PC and then it stopped though no changes were made to the code. That's why I think it may be blocked by an Outlook setting.

Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
MailOutLook.Subject = "E-mail"

View 9 Replies View Related

Excel 2007 :: Compile Error / Sub Or Function Not Defined - Even After Solver Has Been Referenced

May 15, 2014

I get this error : Compile error : Sub or Function not defined. I found out that this might be caused by the solver not being referenced. But, this is fixed now but I still get the same error message.

I'm using Excel 2007 - Windows.

Here is the code :

Sub Macro1()
Dim i As Integer
Dim j As Integer
j = 4
For i = 1 To 4000
If ActiveSheet.Cell(i, 12).Value = 1 Then
ActiveSheet.Cell(j, 15).Value = ActiveSheet.Cell(i, 2)


View 2 Replies View Related

"application-defined Or User-defined Error" When Applying Validation In Vba

Sep 16, 2006

I've made a macro that inserts an entire new row above a specified cell, then updates each column of that row using offset.value and various constants and inputbox variables. Works great so far, unless I try to apply a validation rule to one of the cells.

The code I'm using to add the validation works okay when referring to a specific cell by reference e.g:

With Range("A1").Validation


However, when I change it thusly:

With Sheet2.Range("LastRow").Offset(-1, 5).Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=Departments"
.IgnoreBlank = True
.InCellDropdown = True
End With

It doesn't like that one bit.

This is part of a private Sub attached to a button in the same sheet. I've had a scan through the archives looking for validation threads, but couldn't find anything that refers to problems with offsets (if indeed that is the problem here).

View 9 Replies View Related

Get Compile Error - Sub Or Function Not Defined?

Apr 9, 2014

Trring to use function edate() in VBA macro, I've activated atpvbaen.xls in Tools/Register but get compile error:"Sub or function not defined".

View 5 Replies View Related

Compile Error / Sub Or Function Not Defined

Jul 9, 2014

Have two worksheets in same workbook. First worksheet is "ReArrangedAddr" Which basically has a command button to click to run a "Sub" behind the second worksheet "Orig SH Register". When I click on button on first worksheet, I get error "Compile Error: Sub or Function not defined"

* * * * * code behind command button * * * * *

View 14 Replies View Related

Compile Error - Variable Not Defined

Aug 12, 2014

New to VBA and just trying to make some edits to some existing code. I have basically copied a pre-existing form and module and changed names from "Appendix" to "Drawing" as I am trying to replicate what the piece of code already produces for a table of appendices, for my drawings.

However, when I try and run the form I get Compile error: Variable not defined with lstDrawings highlighted.

[Code] ...........

Is this something that should be defined in my global module which I am missing?

View 3 Replies View Related

Compile Error - Variable Not Defined

Jan 21, 2012

The following code has been used previously to enter data from a userform to a worksheet without a problem. However, since I added some new bits of code I am getting a compile error with the message variable not defined.

Here is part of what I have so far and the bit that is highlighted after the error comes up is the 'Set ws' line;

Private Sub CommandButton1_Click()
Worksheets("Duties").Range("C5") = txtdate
Worksheets("Duties").Range("H5") = txtarea
Worksheets("Duties").Range("N5") = txttea
Set ws = Worksheets("Duties")
'find first empty row in database
iRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

The code I have recently added:

Private Sub UserForm_Initialize()
Set wsRes = Worksheets("Resources")
With wsRes
.Range("B1", .Range("B" & Rows.Count).End(xlUp)).AdvancedFilter xlFilterCopy, , .Range("L1"), True
With .Range("L2", .Range("L" & Rows.Count).End(xlUp))
cboTeam.List = .Value

[Code] .......

View 8 Replies View Related

Compile Error / Sub Or Function Not Defined

May 17, 2012

I have a two set of Macros in a workbook. One is to create a command button on a sheet and other macro will run onece the created commond button is clicked.

Macro runs fine. Command button gets created, but when I click the command button to run another macro it gives error "Compile Error: Sub or Function not defined" highlighting the code "Call Add" at the code entered for sheet. This code is added by macro in the sheet1. I am attaching a sample file as well as codes.

Sub CreateButton()
Dim Obj As Object
Dim Code As String
'create button
Set Obj = ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", _
Link:=False, DisplayAsIcon:=False, Left:=600, Top:=30, Width:=100, Height:=35)
Obj.Name = "InsertInvoiceButton"
'buttonn text


View 9 Replies View Related

VBA - Label Not Defined Compile Error?

Jun 30, 2014

why this would suddenly stop workin and start giving the above? Error occurs on the first GoTo ExitProc

Sub ConsolidateDataUsingFileList()
'--Purpose is open each file specified in sheet Info, then copy
' that file's data and append it to the dataset


View 3 Replies View Related

VBA With Compile Error: Variable Not Defined

May 27, 2008

I've used Excel for many years, but finally am learning VBA, using Excel Progamming for Dummies by John Walkenbach. Excel is version 2000.

I've searched extensively on Google and on the MrExcel site for the solution to my problem, but still haven't found it . Any direction would be most appreciated.

I'm trying to execute the examples in the book, and have gotten the error message "Compile error: Variable not defined" with "MyString =" highlighted with several of the examples. Could someone please tell me where I'm going astray?

Following is the latest subroutine I typed into the module, from page 124:

Option Explicit

Sub GetLength()
MyString = "Hello World"
StringLength = Len(MyString)
MsgBox StringLength
End Sub

View 9 Replies View Related

Compile Error - Variable Not Defined

May 6, 2009

I keep getting 'compile error - variable not defined' in the following

Sub LockIt()
TextBox1 = ""
End Sub

View 9 Replies View Related

Getting A Compile Error Variable Not Defined

Jan 13, 2010

It works as a regular Module but when I put it into a "Private Sub" for a button its not working.

Basically I have a master sheet that I create Tests from. I push a button and it creates a Test for others to take. I want the macro to transfer from the Master to these so when they are done I can press a button and upload the answers to a tracking sheet.

It errors on the strSecondFile

Private Sub CommandButton1_Click()
Dim wbk As Workbook
Dim NAME As String

'strFirstFile = ActiveWorkbook
strSecondFile = Application.GetOpenFilename
Set wbk = ActiveWorkbook 'Workbooks.Open(strFirstFile)
NAME = Range("A6").Value

View 9 Replies View Related

Compile Error: Variable Not Defined

Jul 18, 2006

I came across a weird situation using a standard print macro. One of my users could not use the print macro due to a compile error. The row that was highlighted was

.PrintErrors = xlPrintErrorsDisplayed

the error states that the variable is not defined. I removed that line of code and everything prints fine.

I tested this code out on excel 97 and it worked; is this sensitive to OS version? Will leaving this line of code effect anything big?

View 9 Replies View Related

Compile Error: Sub Or Function Not Defined

Jul 28, 2006

Can someone explain the concept of defining the "Sub" to me.

View 5 Replies View Related

Excel 2010 :: Overflow Error 6 - When All Variables Defined As Integers

Jul 17, 2012

I have tracked down an overflow Error 6 to the following line:

dMax = Int(s * DPoints / SPoints)

Where all variables are defined as Integers. The error goes away when I define s as Long, but I don't understand why this should be required since none of the individual variables ever exceed the scope of an Integer (-32768 to 32767).

Strangely, I get the same overflow problem when I type either of the following calculations in the immediate window:

? Int(328 * 100 / 1000)
? 328 * 100 / 1000
? 328 * 100

Note that no variables are defined, so why the overflow problem? Surely Excel/VBA should be able to work with this very basic calculation without any problem, by assigning the appropriate dimension, no?

Is this a known problem with Excel/VBA?

I am using Windows 7, with Excel 2010 (updated from 2009).

View 9 Replies View Related

Defined Function - Compile Error Block If Without End If

Mar 17, 2014

I have created the following defined function in excel VBA but i get the complie error:-

'Block if without end if'

This this the code I have written for the function:-

Public Function Rule_45(Current, Previous, Result)
' RED: 'Decreasing Trend' OR 'Same' AMBER:'Increasing Trend' GREEN:'>83%'
If Result = "-" Then
Rule_45 = "-"


View 2 Replies View Related

Clearing A Variable Of User Defined Type

Nov 3, 2004

I am currently working in an application in which I use the following user defined types:

Public Type correlationstruct
corr As Variant
corrstd As Variant
lower As Variant
upper As Variant
support As Variant
End Type

I have a public variable called myctafund, of type ctafund:

Public myctafund As ctafund

My problem is the following: When I need to update myctafund, I first want to clean it entirely before putting new values, so as to be sure older values do not stick around (I do not necessarily overwrite all the values of the mycta type).I can't figure out a way of clearing the entire myctafund variable in one shot. I tried:


but I am granted by a nasty excel error. I'd like to avoid writing 200 lines of code just to clean the entire variable.

View 9 Replies View Related

New Collection Of User Defined Data Type

Jun 23, 2006

I can create my own new collection which is handy as it accepts uniques only and i can access using its "key"

But can i have a collection of "user defined data types"

View 5 Replies View Related

Compile Error: Sub Or Function Not Defined - 3-line Macro

Jun 18, 2009

I'm trying to use MATCH to identify the Column number that contains "DL_Error", then I'll use this Column # to select a cell (found Column # & "34"), but I get the error shown in the title of this post.

Here's my current
Sub Macro15()
' Macro recorded 6/18/2009 by me
Range(Match("DL_ERROR", "A31:CW31", 0) & "34").Select
End Sub

View 9 Replies View Related

Pass Element Of User-Defined Data Type

Oct 17, 2007

I have an array with structure, i.e. User Defined Type. Assume the user defined type has two elements: Element1 and Element2 and array name is Array.

So the definition is:

Dim Array(1 To 10) As UserType

and access to elements is


The problem is that I need to pass the whole set of Element1 or Element2 to a function. Should it have been two separate arrays, it would not be a problem. But because of the user defined structure I have no idea how to pass a single element.

I hope there is another solution rather than to use loops. I have many arrays like this with complex structures. I simply can not replicate all of them.

View 9 Replies View Related

Compile Error - Variable Not Defined Involving Multiple If Statements

Jan 27, 2014

I am trying to put two subs into a macro. They work individually, but when I put them together, I get a "Compile Error: Variable Not Defined" Message. I was told I have to define the variable in the sub multipleif(), but I am not certain as to how to do this. The error message highlights the line I have bolded below.

Option Explicit
Private Sub CommandButton1_Click()
Dim mth As Variant, txt As Variant, des As Variant, wdt As Variant, I, Cell


View 5 Replies View Related

Microsoft Visual Basic: Compile Error: Sum Or Function Not Defined

Mar 24, 2006

I receive: "Microsoft Visual Basic Compile error:

Sum or Function not defined" after I have run a macro. I recorded the macro.

The macro code is: ..

View 12 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved