Listbox CellTextChange Event

General
1

I want the listbox cell just ipaddress,So I have to filter other characters.But I found some problems

In Listbox1.CellTextChang event.

me.Cell(row,column) = "Hello"

So When I change the content of cells,Events will be triggered.Content of cells will become “Hello!”
But there is no effective, Who can tell me why ? Thank you very much.

2

When you are editing a cell, it is using ActiveCell. You need to set that.

me.ActiveCell.Text = “Hello”

3

Thank you ! ???