Command buttons

[RoboRaz]

Hello,

I'm new here and I think this is a fantastic community. I need some help here since I'm very new to excel's developer option.

I would like to know how I could use a command button to address a cell value into a Text box.

I want the user to click on a button and update values in multiple text boxes from different cell values and also update charts along with it so I'd like to know what code will go behind it.

Thanks!

 

[RoboRaz]

Re: Need help with command buttons

Hope you don't mind my ignorance there I went into another direction since I'm a bit short on time

 

[My Aswer Is This]

Re: Need help with command buttons

Not sure if your needing more help or just commenting. Looks like you have a grasp on writing code and working with ranges. I'm not use to dealing with charts very much.

 

[RoboRaz]

Re: Need help with command buttons

Not sure if your needing more help or just commenting. Looks like you have a grasp on writing code and working with ranges. I'm not use to dealing with charts very much.

Sorry mate English is not my first language so I might not make sense but I'll try to make it as clear as possible from my side. I do need help.

I would like to know if there is a way in which I could select my desired column's within a range of columns I have assigned. For example, if I write Range("A1","C1"), it would mean that I am selecting columns A,B,C right? But if I only want to select columns A and C, is there any way I could do that?

Or do I have to use Cell instead of Range?

 

[My Aswer Is This]

Re: Need help with command buttons

Here is a example if you want to select the entire columns:

Sub Select_Me()
Range("A:A,C:C,F:F").Select
End Sub

This will select columns A C and F

 

[My Aswer Is This]

Here is a example if you want to select individual cells:

Sub Select_Me()
Range("A1,C1,F1").Select
End Sub

 

[My Aswer Is This]

Here is another example:

Sub Select_Me()
Range("A1,B45,F75").Value = "Bob"
End Sub