Input Mask

  • Thread starter Thread starter Mark Harrison
  • Start date Start date
M

Mark Harrison

Hi

Is there anyway to create an input mask or format check in Excel using VBA?
I need to validate the entry postcodes on a spreadsheet.

Mark
 
Thank you for your help, it has given me a start, however I am still unable
to create an input mask, I need to check that the first two characters in
the cell are letters and that the next character is to be a number, and so
on, is it possible to do that?

Mark
 
Have you looked at Data=>Validation and use the custom formula approach?

My previous suggestion would have used the change event (target holds a
reference to the cell triggering the event), to examine the contents of the
cell and react accordingly.
 
Back
Top