Display the contents of Data Validation List in Text box

[FryGirl]

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.

 

[JackDanIce]

This link may help:

Use VBA to get Data Validation list and put it in a string.

I need an example of how to get a validation list to a string. I know how to do it with a formula but I do not know how to do it with a validation list. I tried this and it errors out on the first line saying not a supported method: VDL1 = Worksheets("new").Range("J3").Validation...

www.mrexcel.com

I placed a validation list in I5 containing values "a, b, c, d" and ran the following, you could substitute s for your TextBox:

Sub test()
Dim s As String
s = [I5].Validation.Formula1
End Sub

 

[FryGirl]

Thank you Jack for your time. This lead me to rethink what I needed and this did it.

How to Show Data Validation Messages in Textbox

For Excel data validation, show messages to the user by in a text box, at the top of the worksheet

www.contextures.com

 

[JackDanIce]

If it helped, glad it's helped! Thanks for the feedback