J
JSCarpenter
I just discovered the trick I needed to solve this problem I had
trying to use the method "MyData.PutInClipboard"
1.Trying to follow the advice I got from an earlier thread
"You need to ensure that a reference is set to the Microsoft
Forms 2.0
library in Tools References in the VBA editor. This reference is
automatically set if you include a UserForm within your project."
wasn't successful, because the Microsoft Forms 2.0 library DIDN'T
APPEAR in the list.
2. then I tried putting a textbox on the form, because that was in the
Example. Again, the DataObject type was flagged as "undefined".
3. Ah! but here's the trick. Having put the textbox on, then taken
it off the form, now suddenly the Microsoft Forms 2.0 library appeared
on the list, I checked it, closed the dialog, and the macro now
worked! Doing both was the secret.
Greatly relieved! Hope this helps someone.
JSC
trying to use the method "MyData.PutInClipboard"
1.Trying to follow the advice I got from an earlier thread
"You need to ensure that a reference is set to the Microsoft
Forms 2.0
library in Tools References in the VBA editor. This reference is
automatically set if you include a UserForm within your project."
wasn't successful, because the Microsoft Forms 2.0 library DIDN'T
APPEAR in the list.
2. then I tried putting a textbox on the form, because that was in the
Example. Again, the DataObject type was flagged as "undefined".
3. Ah! but here's the trick. Having put the textbox on, then taken
it off the form, now suddenly the Microsoft Forms 2.0 library appeared
on the list, I checked it, closed the dialog, and the macro now
worked! Doing both was the secret.
Greatly relieved! Hope this helps someone.
JSC