I don't know who originally wrote this but I use it all the time for formatting SQL to a VBA SQL statement. I modified the conversion of vbCrLf to VbNewLine. (The old form is still there) I read somewhere that VbNewLine was just a little faster than the vbCrLf. Who knows?
It could use a little more modification that I haven't done yet. Like: Automatically copying the new statement to the clipboard. (You have to use Ctrl+C after highlighting)
Hope someone uses it as much as I do!
It could use a little more modification that I haven't done yet. Like: Automatically copying the new statement to the clipboard. (You have to use Ctrl+C after highlighting)
Hope someone uses it as much as I do!
