Help with Spin Button. Set Spin button starting value based on a text box value

I cant really figure out how to manipulate this spin button

I have a simple userform with a textbox and spin butto
The textbox displays the value that is found in column a in sheet 1

say there are 10 rows
row 1 value is "a"
row 2 value is "b" down to row value 10 is "j"

what I wan to achieve is to use the spin button where the and down button will display the next or previous cell value thats is displayed in the textbox.

for example if I write "f' in the textbox when I hit the up button it should display "g" or it will display "e" if I hit thr down button.

what Ive been doing is that when I put a value let us say c when i press the up or down button it will go back to a not yo d or b respectively. thank you in advance.

I dont have a file yet. can you give me a idea on how can it be done? thank you

Here is the file

anyone please?

Here is an update. This works only for your specific example. If the user types a letter into the textbox, the code will look up what position that letter is in. The value of the spin button has to stay in sync with that, because you are using that value as an index to your list of values.

However, if you use complex data of more than one letter, the textbox change event will fire every time the user types the first letter, and it will not match. I suggest you use a listbox instead of a textbox. Then you don't have to check for errors if the user enters something invalid.

this works perfectly! Thanks!

Originally Posted by 6StringJazzer

Here is an update. This works only for your specific example. If the user types a letter into the textbox, the code will look up what position that letter is in. The value of the spin button has to stay in sync with that, because you are using that value as an index to your list of values.

However, if you use complex data of more than one letter, the textbox change event will fire every time the user types the first letter, and it will not match. I suggest you use a listbox instead of a textbox. Then you don't have to check for errors if the user enters something invalid.

The example you made only works for textvalue character length what if you have more than 1 character? a word perhaps

nevermind I got it. It has something to do with data type. thanks again!