Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Josefina Stanley   on Oct 15 In MS Office Category.

  
Question Answered By: Tamara Nguyen   on Oct 15

The macro recorder will give a trail of the commands you issue, Select Cases
are beyond its' capabilities.



The macro recorder is used to find out what code is needed to replicate
specific UI actions. Once you have determined the VBA equivalent, you can
add the code snippet to the Select Cases structure which is well documented
in the VBA help. So the big advantage to the recorder is to get an idea of
what codes are needed to replicate a specific UI action. You should then
have some method names or keywords to focus your research. If you get
several keywords, Google them and see if an example pops up.

Share: 

 

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

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


Tagged: