Data Entry Restrictions & Date/Time Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that multiple users will be using. I would like to restrict data entry to all caps. Is this possible? Also, I would like each line of the spreadsheet to display the current date & time of the entry. I would like this step to have as little of an impact on the user as possible. Any suggestions would be greatly appreciated. Thanks!
 
You can't restrict entry to all caps - in Edit mode, any code you
write will be suspended. However, you can use a worksheet_Change
event macro to convert to upper case after the entry is made.

But first, for how to date/time stamp an entry, take a look at

http://www.mcgimpsey.com/excel/timestamp.html

Since this uses a worksheet_change() macro, you can add the line

.Value = UCase(.Value)

after the

Application.EnableEvents = False

line to convert the user's entry to upper case.
 
How do I add the following code?

Since this uses a worksheet_change() macro, you can add the line

.Value = UCase(.Value)

after the

Application.EnableEvents = False
 
Back
Top