worksheet_selectionchange(VBA) - not working properly?

[DADAZHU]

Hi,

I ofter use a combobox in worksheets when a particular cell is clicked, then the combobox will appear over the cell with a number of options for users to choose, once a value on the list is selected the combobox will disappear. the cell's value is left with the selected value.

It works fine for me. However, me problem is the 2nd click following the 1st click, say, I click the same cell after the 1st click, I expect that the combobox will appear again, however, nothing happen, I have to click somewhere else first, and come back to click the cell, the combobox then appears.

Does anyone know how to overcome it?

Many thanks in advance.

David

 

[shg]

If you click the same cell twice, the selection doesn't change, right?

 

[DADAZHU]

Thanks for your response.

The problem is that the event was fired at the 1st click, but nothing happens on the 2nd click (when the same cell is still selected).

I tried to select another cell before the 1st event is completed, so the 2nd click on the same cell will work, but the result was not good.

 

[shg]

There is no event fired when you select the same cell twice.

You could instead double-click, and use the doubleclick event.

 

[DADAZHU]

Thanks, shg.

Did you mean use 'Worksheet_BeforeDoubleClick'? it is the only event I can find with worksheet. Even though I still have the same problem. Once the 1st event fired, the 2nd click or doubleclick doesnt work with the cell is selected, unless it is forced to have another cell selected before the 1st event completed, then the user can be fire another event with the cell.

The combobox is not with a form, it is within a worksheet, it's only visible when a user click a fixed cell.

 

[shg]

If your options are configured to enable in-cell editing, thjen you need to cancel so that the double-click doesn't leave you in edit mode, requiring you to exit the cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
    
    ' do your stuff ...
End Sub

 

[DADAZHU]

Thanks so much, shg.

It works!!!