View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default Right icw getfromclipboard

Jacob,

Thanks (again)

"Jacob Skaria" wrote:

Try

TextBox1.Text = Right(MyData.GetText, 19)

--
Jacob


"Basta1980" wrote:

Hi all,

Need a quick fix on this one;

Private Sub CommandButton2_Click()

Dim MyData As DataObject
Set MyData = New DataObject
MyData.GetFromClipboard
TextBox1.Text = MyData.GetText
End Sub

I only need the last 19 characters from the right displayed in textbox1. How
do I incorporate the right function in this procedure?

Regards

basta