Modification to msg box in excel vba

[BORUCH]

Hi
i would like to make some modification to my code here, if Anyone can help me i would greatly appreciated

Please Login or Register  to view this content.

#1 i'm getting an overflow error (error 6) at this code (NumRows = Range("C2", Range("C2").End(xlDown)).Rows.Count) its happening if there is only one reminder in the list

#2 In column "D" i'm capturing the user name of the person who created the reminder, if possible to modify the code that it should only show me reminders for the user that has this workbook open, not all reminders in the reminders sheet.
Something like (if application .user name = anything in column D then it should only show me his reminders

thanks

[JLGWhiz]

This should take care of the first issue. Change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

You lost me on the second issue. I don't know where in the code you are referring to.

[Norie]

#1 Declare NumRows as Long instead of Integer.

Please Login or Register  to view this content.

#2 Perhaps something like this.

Please Login or Register  to view this content.

[bakerman2]

@ Norie.
Probably a typo but

Please Login or Register  to view this content.

[Norie]

bakerman2

Yep, getting late here - almost nodding off.