Dropdown List - Change Display

Well, the solution most likely depends on what kind of dropdown list you're using.

If you're using a drop-down ("combobox") from the Controls Toolbox, you can code a Change event that will set any cell's value to whatever you want. For example:

Please Login or Register  to view this content.

If you are using a data validation drop-down list, you could use a Worksheet_Change event to do something similar, although you couldn't have the validation drop-down list and result in the same cell.