+ Reply to Thread
Results 1 to 1 of 1

Unable to clear combobox content with Backspace

Hybrid View

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unable to clear combobox content with Backspace

    I would like to be able to claer my combobox content by clicking on my backspace key. Right now I am stuck with a partially blue shaded word. please help

    Private Sub SComboProj1_Change()
    Dim r As Double
    Dim rng As String
    
    Worksheets("Sheet1").Activate
    LastRow = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.Count
    
    
    For r = 1 To LastRow
    rng = "A" & r & ":A" & r
    Range(rng).Select
    
    If ActiveCell.Value = SComboProj1.Value Then
    GoTo Msg
    End If
    Next r
    
    
    Msg:
    
    
    Worksheets("Sheet1").Activate
    
    
    SComboClient2.Text = Cells(r, "B")
    STxtClientCon.Text = Cells(r, "D")
    STxtDate.Text = Cells(r, "C")
    STxtDetail.Text = Cells(r, "E")
    
    End Sub
    Moderator's Edit: I have moved your thread to the right subforum. Also, use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.
    Last edited by arlu1201; 11-16-2012 at 05:54 AM.

+ Reply to Thread

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