Using VBA code to randomly generate words without repetition

I am working with vba to create a quiz term generator. I have a column of words in cells B5 to B160. I am trying to make a code that will randomly generate a word without any of them being repeated. I am little stumped as to where to start. We are told we must use Durstenfeld's algorithm to do this. Any help would be greatly appreciated!

Thanks!

Please Login or Register  to view this content.

Will reorder the list using Durstenfeld algorithm

Hey thanks for the help pjwhitfield!

I am also having trouble making a code that will display these terms via a user form. What I am trying to do is generate a flash card quiz that displays these terms randomly once the 'start' button is pressed. I am also trying to create a code for the 'reset' button that resets the entire quiz. We are told to use a static integer, but I'm not sure how this code works or how to combine it with the Durstenfeld algorithm. The code that we are supposed to use looks something like this:

Sub GetItem(Optional reset as Boolean)
Static m as integer
If reset then m = 0
UserForm1.Label1 = m
End Sub

Where we want to display the mth element of the randomized vector.

Any ideas on how to incorporate this?

I know this is a lot, but if you could help me incorporate this code or point me in the right direction, that'd be great!

Thanks again!