Excel Function

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
 
V

Vasant Nanavati

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top