Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have written the following lines:
Range(Person).Select If Range(Person).Select "" Then resp = MsgBox("The person you have selected already has comments." & Chr(13) & "Do you want to overwrite?", 4, WARNING) If Response = vbNo Then Windows("Personwin").Close Exit Sub If Response = vbYes Then End If End If End If Basically the person can change depending on the input. But, each person has their own column and if the column already has comments, then I want to be sure the user wants to write over these comments. If the answer is 'no', then I want the window closed that was opened to receive the comments (Personwin). If the answer is 'yes', then I want the macro to continue with recording the comments, etc. When the macro runs and I click 'no', the macro continues instead of closin the window and stopping. Can someone please explain what I did wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking up and create driving directions | Excel Discussion (Misc queries) | |||
Need general directions | Excel Programming | |||
web query for driving directions | Excel Programming | |||
V/HLOOKUP in both directions? | Excel Worksheet Functions | |||
Lookup 2 directions | Excel Worksheet Functions |