I've created a userform and have several user defined inputs I want to be placed in a user defined column. I have the user enter a letter (and would need them to be able to go past z i.e. AA and beyond). I would like to use the range("letter#").select function but do not know how to use it with a user defined letter. I've tried textbox1.value = X and then range("X1").select and several variations but it wont work. Please help.
Hello powers023,
Welcome to the Forum!
I am not clear on what you want to do here. If you want to define a range in A1 notation then the variable should be a string type. The example below selects the cell "AA25" on the ActiveSheet. As long as the string is a valid range, the code won't error.
Dim Addx As String Addx = "AA25" Range(Addx).Select
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks