CellGotFocus behaviour

General
1

Just a heads up for anyone who’s had this problem
I was using the code below to prevent users from deleting the contents of a listbox cell
CellAction event:
if trim(me.cell(row,column)) = “” then
me.cell(row,column) = OriginalCellValue // OriginalCellValue is a property set by the CellGotFocus event
beep
MsgBox “Cell cannot be left blank”
end if

line 2 of this code doesn’t work. It appears that the first line of this code actually triggers the CellGotFocus event which overwrites the OriginalCellValue with the empty string. Easily fixed but it took me a while to figure out what was going on

2

I find that hard to believe (and it doesn’t happen in my testing). You must have some other code involved somehow.