rahul_r79
08-25-2010, 08:24 PM
Hi All
I am trying to link multiple excel cell value to one Excel Text Box,but its not working only b4 value is coming in the textbox,..Is there is any way I put multiple excel cell value in one Textbox??:banghead:
[VBA]
Public Sub TextBox()
ActiveSheet.Shapes("Text Box 3").Select[VBA]
Selection.Characters.Text = Range("B3").Value
Selection.Characters.Text = Range("B4").Value
Range("B1").Select
End Sub
[\VBA]
I am trying to link multiple excel cell value to one Excel Text Box,but its not working only b4 value is coming in the textbox,..Is there is any way I put multiple excel cell value in one Textbox??:banghead:
[VBA]
Public Sub TextBox()
ActiveSheet.Shapes("Text Box 3").Select[VBA]
Selection.Characters.Text = Range("B3").Value
Selection.Characters.Text = Range("B4").Value
Range("B1").Select
End Sub
[\VBA]