Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Annie Russell   on Oct 09 In MS Office Category.

  
Question Answered By: Gina Tanaka   on Oct 09

Sorry to have been a while getting back to you. I expect you have solved the
problem anyhow but if not, the answer is

Create a module level variable (i.e. declared outside the sub) Call it
ItemEntryReturn

in the click event of the each button  put code like

ItemEntryReturn="Skip"
ItemEnty.Close

In your main code then include a case statement

Select case ItemEntryReturn
Case "Skip"
Goto NEXTFOR
Case "Cancel"
Exit Sub
End Select

If the form  is closed by any means other than Skip or Cancel then the code
will continue running

You may need to change .repaint to .show

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Returning to a Sub from a form Or get search suggestion and latest updates.


Tagged: