Ding sound when value in entered in a cell

[Gerard_Sanchez]

Hi,

I have no background in VBA programming so I would just like to ask if somebody can help me with a VBA code on a worksheet level that gives off the MS Windows "ding" sound when values have been entered to specific cells, i.e., ding sound when value has been entered on cell B50, also ding sound when value has been entered on D130, and so on.

Appreciate any kind of help on this.

Gerard

[JBeaucaire]

1) Right-click on the sheet tab and select VIEW CODE
2) Into the sheet module that appears, place this code:

Please Login or Register  to view this content.

3) Edit the underlined string of cell references. You've been shown how to indicate a several single cells, a range of adjacent cells and an entire column. Edit that to be a complete list of all the cells to watch on this sheet.
4) Now still in the VBEditor, select Insert > Module to add a new empty code module
5) Paste in these codes:

Please Login or Register  to view this content.

(source)

6) Press Alt-Q to close editor
7) Save as a macro-enabled workbook.

Now try changing the values in the cells you chose.

[JBeaucaire]

Some other simple sounds that might be nice:

Please Login or Register  to view this content.

And of course you can drop any sound file you want into the C:\WINDOWS\Media folder and use that as well.