Data Table Refresh Button

[napoleon dynamite]

I'm working on creating some data tables in an excel worksheet. I know that pressing F9 can refresh data tables but other people are going to be using this sheet and I am trying to make it as simple and obvious as possible that the data tables will need to be refreshed. I'd like to put a button that says "Click Me" or something like that next to each data table. I know that if you go into Developer you can insert a rectangle, right click and assign a macro. Where I'm running into a little bit of trouble is actually assigning the macro/writing VBA itself. I am not exactly sure how to "assign"/write the macro so that after I stop recording, anyone can simply click on the button and the data table is refreshed whenever there is updated data in the rows/columns. I'm pretty sure it's possible to do this as I've seen refresh buttons for other things in excel. Any help is appreciated!

 

[RedBeard]

If you in the developer tab choose ActiveX button instead of form button, insert that and double click it.
In the window that appears you should see something like:

Private Sub CommandButton1_Click()

End Sub

If you after the line that says Private Sub CommandButton1_Click() press enter once or twice so you get a new line and then type ThisWorkbook.RefreshAll you should end up with something like this:

Private Sub CommandButton1_Click()

ThisWorkbook.RefreshAll


End Sub

Go back to the sheet, go out of developer mode and press the button.