Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ComboBox issues (Excel XP)

    Hello,
    My problem is this, my combobox's need to be easy to press using a touch screen, but at the moment the arrow part is jsut too small, i tried using the style 2, but the problem arises when the value has to be set to one outside of the list, either that, or it must be possible to select an item twice and still run the module if that item has been selected 2 times in a row. E.G. If i select Yes, a module is run and writes Yes in a list, if i select Yes again, it will not write it again into that list as it's the same value.
    Any ideas? BTW i have tried the Listindex = Null and value = Null but it has an odd effect on the following modules it runs.

  2. #2
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ComboBox issues (Excel XP)

    I have done a fix myself now, if someone has a better suggestion then i will take it up, i placed a large button over the drop down and used ComboBox1.DropDown , it works... however i notice you cannot 'cancel' the drop down by clicking elsewhere, you HAVE to choose an item, but that is acceptable.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ComboBox issues (Excel XP)

    Danny,

    Regarding your issue with making the SAME selection in a Combobox twice in a row:
    I have solved this problem by including code at the end of the ComboBox_Change event that resets
    the selection back to the original.
    Say that the list of Items is:

    Select
    Bananas
    Oranges
    Apples


    Then include code something like:

    Option Explicit
    Public CallingMyself As Boolean


    Private Sub ComboBox1_Change()
    If Not CallingMyself Then ' to avoid repetitive cylcling
    .....your code
    Range("A1").Select

    'Clear the selection box so I can make the same selection again
    CallingMyself = True
    Me.ComboBox1= "Select"
    CallingMyself = False

    End If
    End Sub

    HTH

Posting Permissions

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