A full explanation of this OperaBrowser feature can be found in the OperaWiki.
It allows you to apply custom JavaScript Code to all the webpages you load.
One of the most useful things one can do with that is tagging of the elements of a webpage with site-specific keywords so UserCSSInOpera can be applied on a site-local basis.