| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ActiveCell has a comment then exit sub
I'd be inclined to go with a userform but it would help if you had some
basic understanding of the simple task of appending, prepending, inserting, and replacing string values. As for your attempt here... ElseIf myAE = "Edit" Then oldCmt = ActiveCell.Comment.Text MyComment = InputBox("Enter your comments", "Comments", oldCmt) ActiveCell.Comment.Text Text:=MyComment ...where the existing comment text displays for the user to edit. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's | Excel Programming | |||
| Amend sub to re-hide comment when activecell change to another | Excel Programming | |||
| Exit Field vs Exit Button...... | Excel Programming | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| If a called sub exit, how to the caller exit right away? | Excel Programming | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
