+ Reply to Thread
Results 1 to 5 of 5

"Type Mismatch" Driving me crazy

Hybrid View

SoothSailor "Type Mismatch" Driving me... 08-18-2014, 04:39 PM
Norie Re: "Type Mismatch" Driving... 08-18-2014, 04:57 PM
SoothSailor Re: "Type Mismatch" Driving... 08-19-2014, 09:11 AM
SoothSailor Re: "Type Mismatch" Driving... 08-19-2014, 09:12 AM
SoothSailor Re: "Type Mismatch" Driving... 08-19-2014, 09:11 AM
  1. #1
    Registered User
    Join Date
    07-12-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    67

    Angry "Type Mismatch" Driving me crazy

    So, the "Type Mismatch" error pops up every time I press "Enter". I have no idea what's causing it. There are no consequences when I ignore it. I press "Enter" I get "Type Mismatch", I press "Okay", and then go about my business until I press "Enter again".

    Explain like I'm five.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: "Type Mismatch" Driving me crazy

    Do you have code anywhere?

    Is this only happening with a particular workbook/worksheet?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-12-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    67

    Re: "Type Mismatch" Driving me crazy

    I'm not sure where the error is coming from, there are 12 modules. Is there no way to search for what's causing it? My BEST guess as to where it might be is here:


    Public Function TabOrder() As Range
        Set TabOrder = [AE5,AJ5,G10,G12,G14,G20,H26,AH10,AH12,AH14,AL16,AH18,AH20,H26,Z26,AK26,AA28,F32,M32,AA32,AJ32,U34,AF36,f45,r41,af41,r43,af43,r45,af45,r48,af48,f60,i60,l60,o60,r60,u60,x60,k63,aa63]
    End Function
    
    Private Sub CheckBox1_Click()
    
    End Sub
    
    Private Sub ScrollBar1_Change()
    Call AdjustMax
    End Sub
    
    Private Sub ScrollBar1_GotFocus()
    Call AdjustMax
    End Sub
    
    Private Sub ScrollBar1_Scroll()
    Call AdjustMax
    End Sub
    
    Private Sub SpinButton1_Change()
    
    End Sub
    
    Private Sub Worksheet_Calculate()
    If Range("ak26").Value > Range("br14").Value Then GoTo box1 Else GoTo end1
    box1:
    MsgBox ("Space count Greater than Meter Inventory")
    Range("ak26").Value = ""
    
    
    
    
    
    end1:
    End Sub

  4. #4
    Registered User
    Join Date
    07-12-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    67

    Re: "Type Mismatch" Driving me crazy

    I'm not sure where the error is coming from, there are 12 modules. Is there no way to search for what's causing it? My BEST guess as to where it might be is here:


    Public Function TabOrder() As Range
        Set TabOrder = [AE5,AJ5,G10,G12,G14,G20,H26,AH10,AH12,AH14,AL16,AH18,AH20,H26,Z26,AK26,AA28,F32,M32,AA32,AJ32,U34,AF36,f45,r41,af41,r43,af43,r45,af45,r48,af48,f60,i60,l60,o60,r60,u60,x60,k63,aa63]
    End Function
    
    Private Sub CheckBox1_Click()
    
    End Sub
    
    Private Sub ScrollBar1_Change()
    Call AdjustMax
    End Sub
    
    Private Sub ScrollBar1_GotFocus()
    Call AdjustMax
    End Sub
    
    Private Sub ScrollBar1_Scroll()
    Call AdjustMax
    End Sub
    
    Private Sub SpinButton1_Change()
    
    End Sub
    
    Private Sub Worksheet_Calculate()
    If Range("ak26").Value > Range("br14").Value Then GoTo box1 Else GoTo end1
    box1:
    MsgBox ("Space count Greater than Meter Inventory")
    Range("ak26").Value = ""
    
    end1:
    End Sub

  5. #5
    Registered User
    Join Date
    07-12-2014
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    67

    Re: "Type Mismatch" Driving me crazy

    I'm not sure where the error is coming from, there are 12 modules. Is there no way to search for what's causing it? My BEST guess as to where it might be is here:


    Public Function TabOrder() As Range
        Set TabOrder = [AE5,AJ5,G10,G12,G14,G20,H26,AH10,AH12,AH14,AL16,AH18,AH20,H26,Z26,AK26,AA28,F32,M32,AA32,AJ32,U34,AF36,f45,r41,af41,r43,af43,r45,af45,r48,af48,f60,i60,l60,o60,r60,u60,x60,k63,aa63]
    End Function
    
    Private Sub CheckBox1_Click()
    
    End Sub
    
    Private Sub ScrollBar1_Change()
    Call AdjustMax
    End Sub
    
    Private Sub ScrollBar1_GotFocus()
    Call AdjustMax
    End Sub
    
    Private Sub ScrollBar1_Scroll()
    Call AdjustMax
    End Sub
    
    Private Sub SpinButton1_Change()
    
    End Sub
    
    Private Sub Worksheet_Calculate()
    If Range("ak26").Value > Range("br14").Value Then GoTo box1 Else GoTo end1
    box1:
    MsgBox ("Space count Greater than Meter Inventory")
    Range("ak26").Value = ""
    
    
    
    
    
    end1:
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Code displays error message reading "type mismatch"
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-12-2014, 09:32 AM
  2. Match function works while the "=" says True! Driving me crazy!
    By tony.nz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2014, 02:17 PM
  3. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  4. Replies: 5
    Last Post: 08-08-2010, 03:03 PM
  5. Merged cells cause "Runtime error 13 type mismatch" problem
    By Ralph Malph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2006, 08:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1