Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert text from Comment in 3/4 TextBoxes in a Form
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro-insert text(personal comment) | Excel Discussion (Misc queries) | |||
Macro for special Insert comment text | Excel Programming | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
TextBoxes on a Form | Excel Programming | |||
Form Textboxes | Excel Programming |