Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rainhard Fischer   on Nov 28 In MS Office Category.

  
Question Answered By: Geneva Morris   on Nov 28

I had thought about alternative ways to accomplish this. The two I came
up with was either making the userform  have the information placed in it
and then it updateing the spreadsheet; which was a little more time than
I want to put into this code.

The other and the one I was leaning to was as you said to have more code
connected to the command button on the userform that would complete my
code, but when I did that I ran into a problem  with a nested End Sub in
the main code. See, the userform is nested in an if then statement and
only appears under certain conditions therefore I need an End Sub in the
if statement to end the code. .... Idea just poped into my head. If I
have a GoTo function in the if statement can I jump to the end? Can
anyone help  with the syntax of a GoTo function in the Code? The help
mentions GoTo in the spreadsheet  and a ON...GoTo but not a GoTo in the
code.

Share: 

 

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

 
Didn't find what you were looking for? Find more on pausing code Or get search suggestion and latest updates.


Tagged: