Warning a user?

  • Thread starter Thread starter Microsoft Communities
  • Start date Start date
M

Microsoft Communities

I would like to warn a user that data input for certain cells must be
entered on another sheet. Example:
If the user tries to enter data I would like a box to come up and say "Data
must be entered on Sheet1"

Can someone tell me how this can be done.

Thanks in advance.
Ed Davis
 
Yes, but you would need to use VBA. Why not:
- open your second sheet
- navigate to the cell where you want value copied;
- press '='
- click on the cell in the workbook where the user enters the value
- press [Enter].

Now when the value changes, the second sheet will update without the user
needing to do anything.
 
Hi,

I think you can do this without VBA:

After you have got your sheet designed highlight the entire sheet and choose
Data, Validation, and under Allows pick Custom. Enter the formula A1<>A1.
Activate the Error Alert tab and enter your message.
 
Back
Top