Userform initialise code using also characters

[ipbr21054]

Hi,
I’m trying to put some text in Textbox2 but there are also characters involved of which I stuck with.

Example of what I’m trying to insert including the brackets & comma

(“Put your text here please”),

Please advise Thanks

 

[dreid1011]

Here it is stored as a variable. You can test this piece of code to see if that is what you want. Then just assign the variable's value to the text box.

Private Sub Str_ing()
Dim strA As String
strA = "(" & """" & "Put your text here please" & """" & "),"
Debug.Print strA
End Sub

 

[ipbr21054]

Thanks but i dont undertstand that.
Can you advise the code so i cant just copy it please

 

[dreid1011]

TextBox1.Value = "(" & """" & "Put your text here please" & """" & "),"

Change "TextBox1" to whatever you have named the text box.

 

[ipbr21054]

Keep getting syntax error,d you see why

Private Sub UserForm_Initialize()
TextBox2.Value = "(" & """" & "(MsgBox "ENTER YOUR TEXT HERE", & """" & "),"
End Sub

Im trying to put this is the TextBox
(MsgBox "ENTER TEXT HERE"),

 

[dreid1011]

Maybe this:

Textbox2.Value = "(MsgBox " & """" & "ENTER TEXT HERE" & """" & "),"

or

TextBox2.Value = "(MsgBox " & """" & "ENTER TEXT HERE" & """" & "),"

 

[ipbr21054]

I used the first one thanks

 

[dreid1011]

I used the first one thanks

Glad that worked for you. You're welcome.