Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Carolina Lopez   on Nov 08 In MS Office Category.

  
Question Answered By: Myrtle Wilson   on Nov 08

The negative IF is deliberate. Excel will default your variable to false
("not nested"). This means that you don't need to initialise it
specifically.

I dislike negative IFs from a style point of view. But this is one time
when there is a slight technical benefit.

> Looks like only one var is needed for the
> whole Project.

I use one per module, rather than making them global across the whole
project. However it's unusual to need more than one in any single module.

Variable naming is a very personal thing, of course, but I find "NestedCall"
to be pretty descriptive.

Share: 

 

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

 
Didn't find what you were looking for? Find more on Want to disable a Checkbox_click event Or get search suggestion and latest updates.


Tagged: