Hi!
Is there any way to "Inscribe" a cell?
I would like to run a macro on Enter keypress, that would execute different code depending on that "inscription" that would be invisible to user.
I could use some properties of .Validation property like this:
Code
Private Sub EnterPressed
'following code to ensure proper functioning of Enter in any other Worksheet
if ActiveSheet <> mySheet 'MySheet is global Variable then
ActiveCell.Offset(1,0).Select
exit sub
End If
'now the real code
if ActiveCell.Validation.InputMessage = "1" then
ActiveCell.Offset(0,1).Select
else
'something else
end if
End Sub
Display More
The problem is, I use Data Validation and Conditional Formatting, so can't use any of these properties.
Any suggestions?
Thanks for any help.