ListBox One Click

[Alexis_Colon_Lugo]

Hi

How i make to Works i single click on list box.

i am using CellClick but it get the incorrect value.

Example

i have two row with value
row 1 =“test”
row 2=“test 02”

when i click on the row2 it get the value of the row 1 way

[Tim_Hare]

Use the Changed event. CellClick happens before the highlighted row changes (so you can choose to ignore the click by returning True).

[Markus_Winter]

The first row is row 0, the second is row 1, etc

[Alexis_Colon_Lugo]

ok
thanks

[Emile_Schwarz]

@171942:@Tim Hare

Use the Changed event. CellClick happens before the highlighted row changes (so you can choose to ignore the click by returning True).

In the Changed event, how can you know there was a click ?

[Richard_Brown]

@172225:@Emile Schwarz

In the Changed event, how can you know there was a click ?

Just wondering (as a noob) out of interest how changing rows with the up/down keys rather than the mouse would differ here. I assume using the keyboard would trigger Change but not CellClick, yes?

[Michel_Bujardet]

@172379:@Richard Brown

Just wondering (as a noob) out of interest how changing rows with the up/down keys rather than the mouse would differ here. I assume using the keyboard would trigger Change but not CellClick, yes?

There is no way through the keyboard to trigger a mouse action.

[Tim_Hare]

@172225:@Emile Schwarz

In the Changed event, how can you know there was a click ?

You don’t. And depending on the OP’s needs, it may or may not matter.

[Alexis_Colon_Lugo]

Dim sMoveItems as String
sMoveItems=ListBox1.Cell(ListBox1.ListIndex,1)

i use this with 10 row only and it works file.

this work for me like choice menu