Link to home
Create AccountLog in
Avatar of Curtis Long
Curtis LongFlag for United States of America

asked on

Excel 2010 VB Button

I have a spread sheet that I have attached as a sample.

I would like to add a button somewhere on it that when I click on it, it would rename all the entries in column G row 3 and below from there existing names to the name core.

For example:

Customer 1
Customer 2
Customer 3

Would be renamed to

Core

Can anyone help me with this??

Thanks!!
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Did the file get through?
SOLUTION
Avatar of Shanan212
Shanan212
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Hi,

there was no attachment, but please check out the file I added. If this is not what you want, let me know.


Best regards,

Wim
Map1.xlsm
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If you really want code then this one-liner is sufficient.

Sub changetocode()
Range("G3:G" & Rows.Count).SpecialCells(xlCellTypeConstants).Value = "Core"
end sub

Open in new window

Avatar of Curtis Long

ASKER

Thanks all!!  :-)