Delete Cell Value When Selected

[lsteinbach]

Cant believe I couldnt find this in the archives or google. Maybe its just too simple a fix . . .
Right now I have the cell value as "ENTER", but when the user selects the cell, I would like the text to be deleted, or at least selected, so the user does not have to maunally delete the "ENTER" text.

Thanks in advance!

- Luke

[Mumps1]

Place this code in the worksheet code window. This code assumes that "Enter" is in cell A1. Change the range to suit your needs.

Please Login or Register  to view this content.

[lsteinbach]

Works great! Thanks for the quick reply!

[Mumps1]

Glad it worked out.