Re: hasformat("html")

Right, html format is not a standard format, see these two links https://msdn.microsoft.com/en-us/library/windows/desktop/ff729168(v=vs.85).aspx https://msdn.microsoft.com/en-us/library/windows/desktop/ff729168(v=vs.85).aspx

 

 http://vb.mvps.org/articles/qa200302.asp http://vb.mvps.org/articles/qa200302.asp

 

 PowerPro does check to see if an application has registered the clipboard format as per second link and if so uses that registration to check to see if html format is on the clipboard.  
 

 You need to be using an application that registers and uses html format for this to work, eg MS Word