Putting Code To A Button In Excel / VB

**Rapid** · 04-15-2013, 04:38 PM

I have managed to find online, code to add the date into a cell depending on the properties of that cell which all works fine if I run the code from VB. Now I need to add this to a button command. I am sure this is simple to do but I cannot get it to work. I know how to create the button but I cannot adjust the code to make it work. My code is:

Please Login or Register  to view this content.

Any ideas would be gratefully received.

Cheers

**RS15** · 04-15-2013, 04:41 PM

Go to the developer ribbon - controls - insert - then add a button anywhere you want. When the assign macros box shows up insert the macro you want to attach it to. It is that simple. Good Luck.

-If you found this helpful, feel free to express thanks with the star in the bottom left.

**Rapid** · 04-15-2013, 04:58 PM

Thanks for the quick response. I tried this and I get a 400 error message?

**RS15** · 04-15-2013, 05:30 PM

You getting the error when you press the button? If so it is most likely a problem with the code you have linked to the button.

**RS15** · 04-15-2013, 05:39 PM

What is your VBA code trying to do?

**Rapid** · 04-16-2013, 04:02 AM

It adds the date into a cell if the cell value is Y and as I said it works fine in VB, it just wont work when I add it as a macro on the button.

**RS15** · 04-16-2013, 10:32 AM

VBA Button.xls

I tested it out and it seems to work fine for me. Let me know if this works on your computer, otherwise it might be a problem with your settings.

Also, I am not sure the exact purpose of you VBA code but you might want to add a space between the Y and date or maybe put the date in the adjacent cell.

**Rapid** · 04-16-2013, 12:04 PM

I know what I have done wrong now. The button I have created does not appear on the same sheet as the column that needs changing. Is there a way to associate the code to a certain sheet so I can have the button on a different one? Thanks again for all of your help by the way, I am very new to VB and am constantly making school boy errors.