Error in converting excel columns ro RTF using VB script

[imNidhar]

Hi,

I am getting the below error when concerting excel column to rtf.

complier error:method or data member not found.

below is the code i have used.

Private Sub CommandButton1_Click()
Dim i As Integer

i = 2
While Len(Sheet2.Cells(i, 1)) > 0
Sheet1.ctlTwinACRTB1.RTF1Text = ""
If Len(Sheet2.Cells(i, 4)) > 0 Then
Sheet1.ctlTwinACRTB1.RTF1Text = Sheet2.Cells(i, 4)
Sheet2.Cells(i, 6) = Sheet1.ctlTwinACRTB1.RTF1Text
End If
Sheet1.ctlTwinACRTB1.RTF1Text = ""
If Len(Sheet2.Cells(i, 5)) > 0 Then
Sheet1.ctlTwinACRTB1.RTF1Text = Sheet2.Cells(i, 5)
Sheet2.Cells(i, 7) = Sheet1.ctlTwinACRTB1.RTF1Text
End If
i = i + 1
Wend

End Sub

This i quite urgent..so please help me out.

Thanks in advance

[JosephP]

what is ctlTwinACRTB1? if it's a control added to the sheet it would seem the name is wrong or it does not expose a RTF1Text property

[Richard Buttrey]

Hello and welcome to the forum.

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[imNidhar]

I am not really good at visual basic..there are two sheets..sheet1 has the column which needs to be converted to rtf and sheet2 has the vb interface..when i click the buttuon it throws the error.

[JosephP]

until you comply with the moderator request I can't help you (I'm not sure I can anyway if you can't answer my questions)

[imNidhar]

what is the information you need..??

[JosephP]

please comply with the moderator request