Convert problem

[Ziguratx]

Hey guys, i have i textbox inside useform, and will be putted a column letter, but in my code i want the number that correspond with that column letter. Ex : if someone type “b” in the textbox i want in my cose to show “2”

 

[Marc L]

Hey, according to Excel Objects Model just use the Column property of the Range object like Range("B1").Column …​

​

 

[p45cal]

x = "b"
y = Cells(1, x).Column

 

[Ziguratx]

Hey, according to Excel Objects Model just use the Column property of the Range object like Range("B1").Column …​

​

Did not work here

 

[Ziguratx]

x = "b"
y = Cells(1, x).Column

But i want the a until z, not Just for b=2, like, a =1, c = 3…

 

[p45cal]

I don't know how you grab the textbox contents, so I used a variable x and put a b in it, then to demonstrate the column number code I put the result into a variable y. You need to adapt the code.
It could be
x=textBox1.value
msgbox Cells(1,x).Column

or just:
msgbox Cells(1,textBox1.value).Column

 

[Ziguratx]

I don't know how you grab the textbox contents, so I used a variable x and put a b in it, then to demonstrate the column number code I put the result into a variable y. You need to adapt the code.
It could be
x=textBox1.value
msgbox Cells(1,x).Column

or just:
msgbox Cells(1,textBox1.value).Column

Worked! Thanks man