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 …

I'm using code like this to get text from off the Clipboard. Dim DataObj As New MSForms.DataObject DataObj.GetFromClipboard myString = DataObj.GetText I use error ...

May 15, 2012 · I have found many resources on the internet that do almost what i want to do, but not quite.I have a named range "daylist". For each day in the dayList, i want to create a button on a user …

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

May 14, 2019 · Instead of using the VBA PutInClipboard method, I'm using the PowerShell Set-Clipboard cmdlet, executed by a Shell call, to copy the data to the clipboard. This works without any …

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 to do what you want. …

Nov 17, 2023 · is it possible to disable the multipage in userform so that users cannot click it? If yes, then how should the code be changed instead of putting Me.MultiPage1.value = 1? Also, I can't find …

Apr 18, 2019 · It appears that an MSForms.TextBox implements neither the .Name property or _Exit events - onlt _Change events. Is there a way to determine which specific TextBox generated the event?

Mar 10, 2023 · The spreadsheet will try to rename the MSForms.exd files when it opens. Obviously, this is not a perfect fix: The affected user will still experience the ActiveX control errors when running the …

I have a userform containing lots of text boxes. When ever the values of these text boxes changes, I need to recalculate my end result values based on the textbox values by calling a subroutine Aut...