Create random number when cell changes

Hi. I am trying to create code that will generate a random number and place it in a specific cell when the drop down list selection in another cell in changed. If the selection in the drop down list is "" or "-", I want the cell with the random number to be blank. A new random number would be generated in the cell only if the drop down list selection changes.

The code I have below does nothing as best I can tell, so I've obviously missed something. Any help would be appreciated!

Please Login or Register  to view this content.

Hi

You either need brackets around all of your ranges [ F22 ] or use Range("F22") etc.. throughout your code