Detect column name

[teodormircea]

Hello every one,

I'd like to know if is possible to have the name of a column in a label , when the number of the column is entered in a textbox userform.
Thanks , it will help much

 

[Andrew Poulsom]

What do you mean by name - the value in row 1 of the column?

Private Sub CommandButton1_Click()
    MsgBox Cells(1, Val(TextBox1.Text)).Value
End Sub

 

[teodormircea]

I have like this,

I want to enter the column number in a textbox, from an userform,when i enter the column number a want to see the column name or heather in a label .

 

[teodormircea]

Option Explicit

Private Sub col1_Change()
Dim Col As Byte
Col = Val(col1)
lbcol1.Caption = ActiveSheet.Columns(Col).Cells(1, 1).Value
End Sub