Q:

(Excel VBA) How can I get a button on Excel to display another random cell's data from a list?

I have no prior experience with VBA/Visual Basic/Macros and all that - but I need to create a button that cause a cell to display another random cell's data.
I have a word list of several hundred cells and need a button that will choose one of them to be displayed in a cell at the top of my worksheet. The button needs to be able to be pressed multiple times and still bring up a random word. It doesn't need to have a fail-safe that prevents the same cell being displayed twice in a row.
I don't care how it is accomplished - it just needs to be explained a bit more as I have no idea how VBA works.

A:

I'll give you a starter to assist your learning - (it is Christmas!) and you have the job of researching how to modify it and apply it.  To get you going put this code in a standard code module, adjust the various variables to suit your display/data requirements, add a shape to the spreadsheet and assign this macro to that shape.  My word list is on worksheet "Sheet1"
Sub showRandomWord()
Dim ws As Worksheet
Dim stRow As Long, endRow As Long, dataCol As Long
Dim dispRow As Long, dispCol As Long

Set ws = Sheets("Sheet1")
stRow = 2
dataCol = 3
dispRow = 2
dispCol = 4

    With ws
        endRow = .Cells(.Rows.Count, dataCol).End(xlUp).Row
        .Cells(dispRow, dispCol).Value = _
          .Cells(Application.RandBetween(stRow, endRow), dataCol).Value
    End With

End Sub

