Is there a way to modify my excel vba code from inside the loaded user form? For instance, I have two userforms, one with buttons that copies and pastes text. I want to use the second userform to change what the text is that gets copied and what the buttons shown text is.
The code I use for the copy/paste function is:
Dim obj As New DataObject
Dim txt As String
'Put some text inside a string variable
'PURPOSE: Copy a given text to the clipboard (using DataObject)
txt = "Random Text"
'Make object's text equal above string variable
'Place DataObject's text into the Clipboard
Just to preemptively make everyone aware, no I cannot upload a copy of my workbook.