textbox & cell name

buzz71023

Active Member
Joined
May 29, 2011
Messages
280
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

Active Member
Joined
Jul 26, 2011
Messages
478
You can give ranges names like so. Jut adapt it for your needs:
Code:
Range("A1").Name = "some_name"
 

buzz71023

Active Member
Joined
May 29, 2011
Messages
280
so if i had multiple textboxes would it be

Code:
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
 
Last edited:

buzz71023

Active Member
Joined
May 29, 2011
Messages
280
I guess it would help if they were in the correct order.

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

Forum statistics

Threads
1,086,233
Messages
5,388,604
Members
402,126
Latest member
kalcerro_1

Some videos you may like

This Week's Hot Topics

Top