Dears,
Here is my VBA to make "Beep" sound when "a1" cell is =1, it can work when i put 1 into "a1" cell manually, but it doesn't work when run with macro. Pls help!!
byron
Please Login or Register to view this content.
Dears,
Here is my VBA to make "Beep" sound when "a1" cell is =1, it can work when i put 1 into "a1" cell manually, but it doesn't work when run with macro. Pls help!!
byron
Please Login or Register to view this content.
Last edited by Leith Ross; 05-21-2012 at 12:16 PM. Reason: Added Code Tags
Hello Byron,
The argument Target is a Range object that refers to which cell or cells the user has changed. Here is how your code should look...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith Ross,
I've tried your suggestion but it doesn't work also, do i have something missing? It has a formula in "a1" cell >" =IF(G3="","",1) " & "g3" cell is run by macro to input figure automatically. On the other hand, do i need to specify the sheet no. in the macro or VBA?
Sincerely,
Byron
Hello Byron,
The Worksheet_Change event is not fired by a formula result but only when the user changes the cell value.
Hello Leith Ross,
I'm sorry that i am a VBA beginner, u means the Beep sound can only affect if i put the figure in "a1" cell manually & can't run with automatically macro? Is that correct?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks