This tutorial shows you have to add VBA code to your project to check a value as it is entered into a spreadsheet. This example shows you how to ensure that the user only ever adds data to a cell using capital letters.
This example could also be used to enter the date a cell was changed. The example download contains all the VBA used in this example and only requires very basic VBA skills to understand it.
|
