MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chaning the name in comments box.


Posted by Katie on March 14, 2001 2:03 AM

Hi, I need to know how to change the name in the comments boxes that appear. When I opened the file I gave another users deatils, and now I cannot get my name to display!! Please help!
(This Excel file had shared access on networked PC's)


Posted by Dave Hawley on March 14, 2001 4:21 AM


Hi Katie

Try this:

Sub TryThis()

Dim Reply As Integer
Reply = MsgBox("Select Yes,No or Cancel", vbYesNoCancel, "Katie")
Select Case Reply
Case vbNo
MsgBox "You said No!", vbInformation
Case vbYes
MsgBox "You said Yes!", vbInformation
Case vbCancel
MsgBox "You said Cancel!", vbInformation
End Select
End Sub


Dave

OzGrid Business Applications

Posted by Dave Hawley on March 14, 2001 4:31 AM

I may have missed the ball here, you said Comments Box not Message box.

The default name in Comments boxes is set via Tools>Options|General-User Name.


Dave
OzGrid Business Applications