<div>
Try this<br />
<br />
=CONCATENATE(&quot;A&quot;,A1) where A1 is where the user enters the number
</div>


Try this

=CONCATENATE("A",A1) where A1 is where the user enters the number

<div>
The user will be inputting the value in a userform.....so the value will be stored in sometihng like TextBox1.Value<br />
<br />
How can i reference that value?
</div>


The user will be inputting the value in a userform.....so the value will be stored in sometihng like TextBox1.Value

How can i reference that value?

<div>
Try code below:<br />

<pre><code id="code-8242563">Dim mRow As Long
    Dim mColumn As Long
    Dim mValue As String
    mColumn = ActiveCell.Column
    If IsNumeric(Me.TextBox1.Text) Then
        mRow = Me.TextBox1.Text
        mValue = Me.TextBox2.Text
        Rows(mRow).Columns(mColumn).Value = mValue
    End If</code></pre>
</div>


Try code below:


Dim mRow As Long
    Dim mColumn As Long
    Dim mValue As String
    mColumn = ActiveCell.Column
    If IsNumeric(Me.TextBox1.Text) Then
        mRow = Me.TextBox1.Text
        mValue = Me.TextBox2.Text
        Rows(mRow).Columns(mColumn).Value = mValue
    End If

<div>
<div class="content wysiwyg-content">
How can I take a user inputted row to select a specific cell if the column is specified in the code?<br />
<br />
I've got a userform with a TextBox for the user to enter the row number. <br />
<br />
Say the column I am interested in is Column A...<br />
<br />
If the user inputs &quot;2&quot;.....I want to set the output cell to the value in A2<br />
If the user inputs &quot;43&quot;......A43...etc. <br />
<br />
<br />
Thank you!
</div>
</div>


How can I take a user inputted row to select a specific cell if the column is specified in the code?

I've got a userform with a TextBox for the user to enter the row number. 

Say the column I am interested in is Column A...

If the user inputs "2".....I want to set the output cell to the value in A2
If the user inputs "43"......A43...etc. 


Thank you!

Combine specified column with user inputted row

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.