I am trying to populate a cell with a period after a user types in a number(while the user is still in edit mode). I have tried many of the events but no matter what I can’t get the cell to populate with the period when the user is “editing” it. I have tried calling the following in many of the Events with no luck.
me.cell(me.listindex, 0) = me.cell(me.listindex, 0) + "." me.invalidatecell(me.listindex,0)
The closest I can come to get this working is by putting the above code in the “Cell Action” Event however the period only populates after the user clicks out of the cell.
I have tried the above code in the following events of my Listbox with no luck:
- Cell Action
- Cell Text Change
Is this possible to accomplish?
Any help is much appreciated.