Line of code causing a beeping sound

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I have a line of code that I am using in VB. Not the line of code is
actually VBA code being used in VB (via Visual Studio 2008 Express). It is
giving me a beeping noise. Its the line " .ShowDependents()". Why would this
be happening?

With rng
If .DirectDependents Is Nothing Then
.ShowDependents()
End with

Thanks

EM
 
If DirectDependents Is Nothing, then you are probably hearing beep when the
error message pops up to tell you that there are no dependents for that cell.
Maybe you meant to write If Not DirectDependents Is Nothing Then....
 
Thanks. Will look into it and write back.

EM

JLGWhiz said:
If DirectDependents Is Nothing, then you are probably hearing beep when the
error message pops up to tell you that there are no dependents for that cell.
Maybe you meant to write If Not DirectDependents Is Nothing Then....
Click to expand...
 

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

Similar Threads

How to tell when Beep sound is done? 2
summing through end of row 2
Creating a DLL for Excel 3
How to initiate a sound via VBA? 2
MAximum Lines Of Code 6
How to Call (utilize) a Sub() in a Class DLL? 9
How to separate on very long line of code in VBA 5
Assign a sound to a variable 19

Back
Top