Results 1 to 3 of 3

Problem with TabStrip code - Error Type Mismatch

Threaded View

imzhakmaya Problem with TabStrip code -... 10-08-2014, 06:20 AM
Marc L Re: Problem with TabStrip... 10-08-2014, 07:59 AM
romperstomper Re: Problem with TabStrip... 10-08-2014, 08:14 AM
  1. #1
    Registered User
    Join Date
    08-31-2014
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    18

    Problem with TabStrip code - Error Type Mismatch

    Hi ,


    Can anyone pls help with the below codes "Error Type Mismatch"


    Private Sub TabStrip1_Change()
       Dim i As Integer
       i = TabStrip1.SelectedItem.Index
       Select Case i
          Case 0
             ' First tab selected, change status to start.
             ListBox1.RowSource = StartStats
          Case 1
             ' Second tab selected, change status to end.
             ListBox1.RowSource = EndStats
          Case 2
             ' Third tab selected, change status to Form & Filed.
             ListBox2.RowSource = FiledStats
       End Select
    
    End Sub
    Attached workbook for reference.


    Rgds
    Imzhakmaya
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Error 13, type mismatch from code.
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2014, 05:14 AM
  2. VBA Code Run-time Error 13 - Type mismatch
    By jmancha in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-16-2013, 11:15 AM
  3. [SOLVED] Getting ‘Type mismatch’ error using Vlookup in VBA code
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2012, 11:22 AM
  4. type mismatch error in code
    By strikeofdawn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2008, 08:34 PM
  5. [SOLVED] Type Mismatch error in VBA code
    By bobby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2005, 04:10 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