Results 1 to 5 of 5

Cascading ComboBox Runtime Error

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    34

    Cascading ComboBox Runtime Error

    Im getting a runtime error 380, invalid property value.

    Any Ideas?

    Private Sub ComMotSCM_Change()

    Dim strRange As String
        If ComMotSCM.ListIndex > -1 Then
           strRange = ComMOTcm
           Labeltest.Caption = strRange
           strRange = Replace(strRange, " ", "_")
                With ComMOTcm
                    .RowSource = vbNullString
                    .RowSource = strRange
                    .ListIndex = 0
                End With
        Else
           Labeltest.Caption = "CM"
        End If
    End Sub
    Last edited by baisty182; 12-02-2010 at 09:27 AM.

Thread Information

Users Browsing this Thread

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

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