Button to display a formula result in a different cell

I'd like to insert a button on a spreadsheet that, when pressed will use a formula to calculate a result and display that result in a different cell. Before that button is pressed though, I'd like the destination cell to display some text.

The formula I'd like the button to calculate is =PROPER(TEXT((TODAY()+'DATA CALC''S'!G16),"MMM DD, YYYY"))

The destination cell is I14.

Thanks in advance to anyone that helps!

Hello boogeyman,

Welcome to the Forum!

Here is the button macro...

Please Login or Register  to view this content.

Adding the Macro

1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
   
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

That's great!
It's putting the date in there perfectly!
Just to tweak it a little more though....
Is there any way to have a few words in the destination cell (I14) if the user hasn't pressed the button yet? Sort of a reminder that they haven't performed that calculation yet...
Like a default phrase that gets replaced by the date when the button is pressed, but reloads to the default phrase everytime the workbook is opened.
Thanks a million for the speedy, detailed response!
It is really, really appreciated!

P.S. should AutoLoad be set to true or false?

Hello boogeyman,

The Workbook_Open() event can load a default value into the cell. You may need to change the worksheet name to match your sheet's name. Change the default text to what you want.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

Hello boogeyman,

That is my fault. I posted the wrong installation procedure! Let's try this again. Delete the previous macro code from your workbook and let's start again.

Please Login or Register  to view this content.

How to Save a Workbook Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S

Hello boogeyman,

Post your workbook so I can review what is happening. If everything is where it should be then there should be no errors.

Hello boogeyman,

Here is how to attach a file...

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Hello boogeyman,

You can email the workbook to [email protected]. However, I will post the code that solves the problem without any data that is confidential or sensitive.

Hello boogeyman,

I received the workbook and am examining it.

Hello boogeyman,

I am emailing the updated workbook to you. Here are the changes that were made.
The code below has been removed from the "Combination" worksheet.

Please Login or Register  to view this content.

This code has been added to the ThisWorkbook module.

Please Login or Register  to view this content.

Hello boogeyman,

You don't need to make any changes. I added them to the workbook I am sending you. The Workbook_Open() event should have been this...

Please Login or Register  to view this content.