tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
Cells A1 and A2 on my worksheet take their data from a list, cells C1 through to C5, which contains the values 1,2,3,4,5.
The Data Validation Error Alert setting has been set so the checkbox, "Show error alert after invalid data is entered" is UNCHECKED.
When I enter a value, such as Apple into cell A1, it accepts it (as expected). Then when I click into cell A1, the drop down shows the options (1,2,3,4,5).
The problem is when I attempt to enter two values (simultaneously) into cells A1 and A2. Suppose I copy values Apple and Oranges from cell D1 and D2 and paste onto cells A1 and A2.
Again these two values are accepted.
However, the drop down options no longer show.
If there a way round this?
Thanks
The Data Validation Error Alert setting has been set so the checkbox, "Show error alert after invalid data is entered" is UNCHECKED.
When I enter a value, such as Apple into cell A1, it accepts it (as expected). Then when I click into cell A1, the drop down shows the options (1,2,3,4,5).
The problem is when I attempt to enter two values (simultaneously) into cells A1 and A2. Suppose I copy values Apple and Oranges from cell D1 and D2 and paste onto cells A1 and A2.
Again these two values are accepted.
However, the drop down options no longer show.
If there a way round this?
Thanks