Hi
Can anyone help me with this coding problem that has been driving me nuts.
I want to select a text box and insert text, as in this example which works well.
Selection.Characters.Text = "mytext"
However what I am trying to do is for it to accept the text in A1 of the activesheet. I have tried code like this without success:
Selection.Characters.Text = "mytext" & Range("A1").Value
Selection.Characters.Text = Range("A1").Value
Also tried to dim Range("A1").Value as a string or variant without success.
Please can someone explain to me the correct way of doing this.
Many thanks in advance
regards
Derek
Can anyone help me with this coding problem that has been driving me nuts.
I want to select a text box and insert text, as in this example which works well.
Selection.Characters.Text = "mytext"
However what I am trying to do is for it to accept the text in A1 of the activesheet. I have tried code like this without success:
Selection.Characters.Text = "mytext" & Range("A1").Value
Selection.Characters.Text = Range("A1").Value
Also tried to dim Range("A1").Value as a string or variant without success.
Please can someone explain to me the correct way of doing this.
Many thanks in advance
regards
Derek