what's on clipboard 1

[mscallisto]

Is there a short-cut to view what's on the clipboard at any one time.

e.g. I highlite and copy something then get distracted and can't remember if I did the copy or not.

I can, of course, do a paste somewhere to see the clipboard contents but was wondering if there is another way to see whats on the clipboard without pasting.

 

[TonyJollans]

Assuming you mean the Office clipboard, it depends what version of Office you're working with.

The clipboard in Office 2000 can be shown by View > Toolbars > Clipboard. In Office XP and 2003, it shows in the Task Pane and can be made visible either via the Task Pane or by Edit > Office Clipboard.

If you mean the Windows clipboard then use clipbrd.exe (via Start > Run)

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[mscallisto]

Thank You very much Tony

sam

 

[mscallisto]

Plus "Edit > Office Clipboard." shows the shortcut [ CTRL cc ]

 

[TonyJollans]

Well ....

Ctrl+C does a copy. By default, two consecutive Copies will trigger the display of the clipboard but this feature can be turned off, and often accidentally is.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[mscallisto]

Well ...

While in any Office program, CTRL +CC (two c's in less 1/2 second) (which is, I believe, the default repeat character delay time) will open up the clipboard window.


I also noticed that some office product needs to be opened prior to doing multiple copies for them to appear in the clipboard window.

I closed all Office products, then did 3 copies to clipboard, then opened a word doc and viewed the clipboard and saw only the last copy.

 

[TonyJollans]

I don't think key repeat time has anything to do with it - that is to do with how long you have to hold a key before it automatically repeats. Separate keystrokes are (or should be) always registered.

What happens when you press Ctrl+C is that your selection is copied to the Windows Clipboard. If the Office Clipboard is running (if you have at least one Office application running) then the selection is also copied to that.

If you press Ctrl+C again, another copy operation is performed exactly as before but there are a couple of things to note:
[ul][li]If what is copied is exactly the same as what is already on the Windows clipboard it may or may not be overwritten - it's impossible to tell.[/li]
[li]If what is copied is exactly the same as what is already in the latest slot in the Office clipboard it may or may not be overwritten - again, it is impossible to tell - but a new entry will not be added.[/li]
[li]If nothing is selected when a copy is performed, no data is copied either to the Windows Clipboard or to the Office clipboard.[/li]
[li]By default, two successive copy operations (with nothing but an intervening paste) within the same Office application, whether or not any data are actually copied, will trigger the display of the Office Clipboard in that application.[/li][/ul]
So, pressing Ctrl+C twice in, say, Word will copy the selection twice - see above for the impact of the second copy - and display the Office clipboard. If the selection was just an insertion point, nothing is actually copied; if it contains data, that data will appear in the latest slot.

It may or may not help you, but I wrote an article on this subject for VBA Express (and I think you can view it without signing up). The formatting on some of it isn't quite right and I am thinking of expanding it a little but it covers most of what happens.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[mscallisto]

Tony I follow you very well but you may have not understood what I was saying:

while in word, dont hit Ctrl+C twice....Hit Ctrl+C+C and the clipboard window opens.

again the time between C+C must be quick or yes you will get two "copies

 

[TonyJollans]

I must be missing something obvious.

If I let go of Ctrl between the 2 c's, the second one types in the document.

If I don't, then I am pressing Ctrl+C twice and the time between the C's makes no difference.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[mscallisto]

While holding the control key down Hit the C key twice rapidly and the clipboard window opens in word,excel, outlook etc.

I sure hope i'm not the one missing something obvious !!

 

[TonyJollans]

While holding the control key down Hit the C key twice rapidly and the clipboard window opens in word,excel, outlook etc.

Yes it does. It also happens if you hit the C key twice very slowly - hours apart if you do nothing in between.

I'm not disagreeing about the result of the action
I was just trying to offer an explanation of why it happens.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[mscallisto]

Gotcha....Case Closed, Over and Out.

thanks again Tony