Excel Function

  • Thread starter Thread starter David Harrison
  • Start date Start date
D

David Harrison

Hope anyone can help me!!

I have a drop down box with about 6 different names init.
What i want to do is that when i choose a certain word or
number in the drop down box i want to make some sort of
sound and for the words or numbers to flash.

Is this possible?

Many Thanks
David
 
Hi David:

I assume you are talking about a validation box. there is no function that
can do what you want; you need to use a macro. Put the following in the
module behind the worksheet and change it to suit you:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing And Target = 6 Then
Beep
End Sub

This assumes that A1 is the cell that you are concerned with.

For fancier sounds you would have to use API calls.

Excel does not support flashing; you would need to write another macro to
accomplish that. I would not advise it as it would use a lot of resources.

Regards,

Vasant.
 
Back
Top