ContextualMenuAction - cell is not updated

General
1

Hello,

The following does not update the selected cell :

Me.CellValueAt(Selected_Row, Selected_Column) = hititem.Text

where I’ve declared Selected_Row and Selected_Column as Window Properties.

I’ve noticed that the cell is updated if I execute a MessageBox(“test”) command before the CellValueAt method.

Is this a bug?

thanks

2

Sounds like the cell has focus / is being edited? If so, you have to set ActiveTextControl.Text instead.

3

Hi Tim,

Thank you for the solution. I’ve made column 0 cells editable and the following works correctly:

If Selected_Column = 0 Then

Me.ActiveTextControl.Text = hititem.Text

Else

Me.CellValueAt(Selected_Row, Selected_Column) = hititem.Text

End If

Thanks again