EXCEL macro how to implement the conditions specified in the order of a
[Users questions | Browse:38 | Favorites]
Users questions:Able to have produced successful EXCEL macro commands (buttons) to specify a the implementation of the conditions is that when conditions do not match, the macro command execution can not, and make prompt. Only when the specified conditions match the, the macro command button can effectively implement - such as designated in the table A1Cell for the "YES", the macro command to perform, if it is other content, that any implementation can not. Please gurus help me solving this problem solution, how like to add this condition has been produced after the macro command. Please help me explain. Rookie hands high score served, thank you!
Experts answer:SubAA () If [A1] "YES" ThenMsgBox "pop-up information can be its own change!!! quotes inside!!!" ExitSubEndIf 'your macro commands EndSub
Experts answer:SubAA () If [A1] "YES" ThenMsgBox "pop-up information can be its own change!!! quotes inside!!!" ExitSubEndIf 'your macro commands EndSub
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.