Insert text from Comment in 3/4 TextBoxes in a Form

E

excelent

Hi Experts
Ned help with a little problem.. her it goes :

Got a Shared Workbook with som Comments around difrent sheets
Now i need to edit these Comments but
cant do this in a Shared workbook, well not without unshare
So im trying to copy text to a userform in 3 or 4 Textboxes
Then i can edit here an write it back to the comment
(well i ges i have to delete old comment and then make a new 1)

There is som Chr(10) in the Text to forse new line
and how do i seperate the whole text to 3/4 textboxes ewery time i meat a
Chr(10)

Here is what i got so far :
Private Sub UserForm_Click()
'Range("A2").Comment.Text Text:="Poul" & Chr(10) & "Madsen" & Chr(10) &
"Town" & Chr(10) & "Postalcode"

x = Sheets("Ark2").Range("A2").Comment.Text

Me.TextBox1 "Poul"
Me.TextBox2 "Madsen"
Me.TextBox3 "Town"
Me.TextBox4 "Postalcode"

End Sub

tks in advance for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to Pull Data into a Comment 2
Brain teaser -- "Passing data from an unbound text in one form to another textbox in another form" 7
how to insert text form field into a table in word application with vb6 2
remove a text row in Excel rpt before the pagebreak with [Placehol 4

Top