Hello, is there a way to check what is the 8th character in a textbox? For example : ABCDEFGHIJK, in this example it would return "H" as it is the 8th character.
Hello, is there a way to check what is the 8th character in a textbox? For example : ABCDEFGHIJK, in this example it would return "H" as it is the 8th character.
maybe...
ActiveSheet.Shapes("Text Box 2").Select Range("A1").Value = Mid(Selection.Characters.Text, 8, 1)
Last edited by Croweater; 11-30-2020 at 05:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks