Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Cristina Riley   on Nov 02 In MS Office Category.

  
Question Answered By: Abasi Massri   on Nov 02

I tried the folowing suggestions:


1. Change 'Private' to 'Public' regarding chkTweak_ Click. Did did
not work

2 Tried to put sbTheta ()in the same module as chkTweak_Click. Did
not work.

3. Refer to Sheet1.chkTweak. Did not work.

4. Put bulk of your code  in standard module, and call  it from event
handler, etc ...
I am pretty sure I can create new subs paint_yellow () and
display_messages (), which together do the same thing as as
chkTweark_Click, except that it will not show the checkbox  as checked.
Well its a 70% solution.

Lesson I seemed to have learned:

1. Event handlers don't want to be called  from subs that are located
in a different module, and

2. Sometimes even from a sub in the same module???

Am I wrong? Have a happy Fourth of july!!

Share: 

 

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

 
Didn't find what you were looking for? Find more on Calling a sub from another sub -- why the error message? Or get search suggestion and latest updates.


Tagged: