textbox & cell name

[buzz71023]

I would like to be able to have a userform define the name of a cell. The formula bar will be disabled/hidden along with being in full screen mode. This will help me from having to take a couple of extra steps in the future.

 

[trunten]

You can give ranges names like so. Jut adapt it for your needs:

Range("A1").Name = "some_name"

 

[buzz71023]

so if i had multiple textboxes would it be

Private Sub CommandButton1_Click()
 
TextBox1.Value = Range("A1").Name
TextBox2.Value = Range("B1").Name
 
End Sub

because I am getting a 1004 runtime error ("Application-defined or object defined error") when I try to run it the way I have it

 

[buzz71023]

I guess it would help if they were in the correct order.

Private Sub CommandButton1_Click()
 
Range("A1").Name = TextBox1.Value 
Range("B1").Name = TextBox2.Value
 
 
End Sub

 

[trunten]

Only just seen this. Yes, your second response is spot on.