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 Starbelow 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