title: How to use column letters in VBA
body: <p>I'm currently struggling with the following problem</p>
  
  <p>I'm trying to implement an input box where a user can input the character of the column. </p>
  
  <p>After that, i dont know how to convert this into a number to use it in the <code>Worksheet.Cells</code> Method</p>
  
  <p><em>For example</em>: The User inputs "B", so the program saves it in a variable named x and converts it into a number so it can be used as <code>Worksheet.Cells(Row, X)</code></p>
  
  <p>Is there any method or does someone has an idea how to do this?</p>