FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
This might sound like a weird request, but is it possible to display the contents of a Data Validation List in a TextBox.
On a sheet I'll have a TextBox, TextBox1. In column T, I have a range T4:T10 which all have individual Data Validation Lists.
When the cursor placed on T4, can TextBox1 show the contents of the Data Validation list. The list might be something like, Red, Black, Blue, and Green.
Of course, I know the user can click the drop down arrow of the Data Validation in that cell and see the contents, just curios if this selection can be shown in a TextBox.
On a sheet I'll have a TextBox, TextBox1. In column T, I have a range T4:T10 which all have individual Data Validation Lists.
When the cursor placed on T4, can TextBox1 show the contents of the Data Validation list. The list might be something like, Red, Black, Blue, and Green.
Of course, I know the user can click the drop down arrow of the Data Validation in that cell and see the contents, just curios if this selection can be shown in a TextBox.