| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line of code causing a beeping sound
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Line of code causing a beeping sound
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.... "ExcelMonkey" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Line of code causing a beeping sound
Thanks. Will look into it and write back.
EM "JLGWhiz" wrote: 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.... "ExcelMonkey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with playing sound code | Excel Programming | |||
| Message box causing error in code | Excel Programming | |||
| Message box causing error in code | Excel Programming | |||
| Workbooks.Open Beeping Problem | Excel Programming | |||
| Sound Code | Excel Programming | |||
Linear Mode
