Sure you can, but you will a numeric value (RGB)
Public Sub Befehl5_Click()
MsgBox ("The background color is: " & myTextBox.BackColor)
End Sub
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
Is it possible in VBA, to reference the values of control properties defined in Design mode when in Run mode?
Example of simple use:
If I set the font color value of a textbox to red in design mode, I want in run mode to be able to reposition that color to red by referencing the design mode color.
The Design Mode color would be used as the default color.
Sure you can, but you will a numeric value (RGB)
Public Sub Befehl5_Click()
MsgBox ("The background color is: " & myTextBox.BackColor)
End Sub
Thank you for your reply.
Maybe I wasn't clear enough in my question.
In my VBA code the font color changes value.
At some point, I would like to reposition it with the color defined in design mode.
How to find this design mode value in VBA?