software

Hi,

I need a screenshot of my desktop triggered by exel.

something like:

if Range(quot;a1quot;).Value = 1 then PRINTSCREEN

Can it be done?

Thanks--
climax
------------------------------------------------------------------------
climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
View this thread: www.excelforum.com/showthread...hreadid=516576Enter this code in the sheet object (not a regular module)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim WatchRange As Range
Set WatchRange = Range(quot;A1quot;)
If Range(quot;A1quot;).Value = 1 Then
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End If
End Sub

quot;climaxquot; wrote:

gt;
gt; Hi,
gt;
gt; I need a screenshot of my desktop triggered by exel.
gt;
gt; something like:
gt;
gt; if Range(quot;a1quot;).Value = 1 then PRINTSCREEN
gt;
gt; Can it be done?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; climax
gt; ------------------------------------------------------------------------
gt; climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
gt; View this thread: www.excelforum.com/showthread...hreadid=516576
gt;
gt;

Correction to previous reply:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim WatchRange As Range
Set WatchRange = Range(quot;A1quot;)
If Union(Target, WatchRange).AddressLocal = WatchRange.Address Then
If Range(quot;A1quot;).Value = 1 Then
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End If
End If
End Sub

quot;climaxquot; wrote:

gt;
gt; Hi,
gt;
gt; I need a screenshot of my desktop triggered by exel.
gt;
gt; something like:
gt;
gt; if Range(quot;a1quot;).Value = 1 then PRINTSCREEN
gt;
gt; Can it be done?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; climax
gt; ------------------------------------------------------------------------
gt; climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
gt; View this thread: www.excelforum.com/showthread...hreadid=516576
gt;
gt;


I need a code that does the same as when I press the print screen
button.
It has to take a picture of my whole desktop and copy it to the
clipboard.
I need to see some results on other programs that are running together
with exel.

Thanks
Johan--
climax
------------------------------------------------------------------------
climax's Profile: www.excelforum.com/member.php...oamp;userid=30816
View this thread: www.excelforum.com/showthread...hreadid=516576
Go to download.com and find screen capture programs. I use one called
Screenprint32. Snagit is another good one.--
rsenn
------------------------------------------------------------------------
rsenn's Profile: www.excelforum.com/member.php...oamp;userid=29050
View this thread: www.excelforum.com/showthread...hreadid=516576