AdrianNeal
New Member
- Joined
- Mar 22, 2019
- Messages
- 5
Hi
i have sheet that allows the user to input data into a cell from selecting it from a Listbox on Userform. The values in the Listbox are from a named Range.
But the user can still manually write directly into the cell and can therefore input any value, even if its not in the named range, and I don’t want them to be able to do that.
is there a away ?
i have sheet that allows the user to input data into a cell from selecting it from a Listbox on Userform. The values in the Listbox are from a named Range.
But the user can still manually write directly into the cell and can therefore input any value, even if its not in the named range, and I don’t want them to be able to do that.
is there a away ?