Return specific value from a named range in a userform

Hi is it possible to return the first value from a named range in a textbox on a userform?

Currently I am using this code to return a list to choose from, I am testing a way to do this with FLOWRAP

Please Login or Register  to view this content.

What I want to do is for this example there are 8 values in the named range "FLOWRAP"

In textbox95 I want to return the first value in that named rang, box96 the 2nd, box 97 the 3rd and so on........

is this possible, if so what do I need to put in my code

Please Login or Register  to view this content.

Any help is great as I cant find anything to help me searching the internet!

Thanks

Dan

Originally Posted by stnkynts

Assuming the cells in the named range increase by 1 row

Please Login or Register  to view this content.

Thanks stnkynts I will give that a go when I am back on the pc ☺

is there a way to change

Please Login or Register  to view this content.

to something like

Please Login or Register  to view this content.

I tried but doesnt seem to work?

Dan

i have found this on the internet

Please Login or Register  to view this content.

But is there a way to change ("Named_Range_Multi") to whatever is in Textbox94?

Dan

Ah yeah i understand they are specific to each individuals workbook (most the time) but using this as a basis to work on it could work, just wondering if it was possible to get the value from textbox94 rather than telling it to look at a specific named range like in this example

Thank you