Add TextBox value to MsgBox

Question

?When I click on CommandButton1 on UserForm1 a MsgBox with the following msg

is displayed. Is there any way to replace XXXXXXXXXX with the value of

TextBox1 of UserForm1?

'Place your text here

MyNote = "This will remove XXXXXXXXXX from the list of Employee Names.

It will not remove the name from the other worksheets. Is that what you want

to do?"

'Display MessageBox

Answer = MsgBox(MyNote, vbQuestion + vbYesNo)

Answer 1

MyNote = "This will remove " & Me.TextBox1.Value

   MyNote = MyNote & " from the list of Employee Names. It will not remove the name from the other worksheets. Is that what you want to do?"

You can use the & operator to concatenate (stick together) any pair of strings, and you can build up a string in stages as in the second statement.

---

Jay Freedman

MS Word MVP  FAQ: http://word.mvps.org

Answer 2

Thank you sir

"Jay Freedman [MVP]" wrote in message news:*** Email address is removed for privacy ***...

MyNote = "This will remove " & Me.TextBox1.Value

   MyNote = MyNote & " from the list of Employee Names. It will not remove the name from the other worksheets. Is that what you want to do?"

You can use the & operator to concatenate (stick together) any pair of strings, and you can build up a string in stages as in the second statement.

---

Jay Freedman

MS Word MVP  FAQ: http://word.mvps.org