Feb 27, 2016 · You don't need Forms 2.0 to work with the Windows clipboard - use the Win32 API instead, see this thread on MSDN

Mar 10, 2023 · The MSForms.exd files are renamed every time the spreadsheet opens, even when there's no issue with the MSForms.exd files. But the spreadsheet will work just fine.

Mar 17, 2013 · When adding controls to a userform, what is the difference between the following. I am confused as to when it is appropriate to use any particular one of these. Dim aButton1 as …

Feb 24, 2016 · I would like to use this library to work with the clipboard. I expect to see it as in the screenshot below, but I can't find it in my list of reference libraries. How can I make it appear?

Nov 16, 2019 · This is one of those techniques that vba will let you do, but you probably shouldn't. For all the same reasons you shouldn't use code that alters your code. That said, here is how …

I would use Dim DataObj As MSForms.DataObject and Set DataObj = MsForms.DataObject (separate lines) to avoid auto-instancing variables. Also, a function would be best suited to …

I'm trying to add a button to a spreadsheet that when clicked will copy a specific URL to my clipboard. I had a bit of knowledge of Excel VBA but it's been a while and I'm struggling.

Apr 18, 2019 · MSForms.Control defines the Enter and Exit events: if you need to handle TextBox.Change, then you need two WithEvents variables: Private WithEvents TextBoxEvents …

May 14, 2019 · It's 2025 now and this problem still persists. My quite simple solution is using PowerShell Set-Clipboard cmdlet: Dim clipboard As New MSForms.DataObject …

Jul 26, 2012 · I need to create labels and buttons dynamically and then add them to a frame within a userform. How do I do this? Seems like it should be easier than it really is.