Clipboard History issue in VB Editor

spilly2010

New Member
Joined
May 12, 2018
Messages
2
If I use Clipboard History in the VB Editor, the text content of the clipboard is hidden unless the Copy was done in Notepad or equivalent.

Copies done in VBE paste OK, but you're pasting blind, which is useless


My problem is that I work in VBE most of the time, and I've never been able to touch type.
(My excuse is, at 80+, it's a bit late now)

It takes me ages, even with Intellisense.
So I use Cut and Paste all the time to avoid typing errors.


I'm looking for a customised Clipboard history always showing the text content
Is there one?
Is this even feasible? If not, could anybody please tell me why not?
 

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,073
There are a bunch of free Clipboard managers for Windows available—too many to choose one to recommend.

Have you tried the built-in Office Clipboard manager? It shows the clipboard history and allows you to select for pasting any of the items shown. Items copied in the VB Editor show up in the pane.

On the Excel ribbon in Office 365, under 'Home', next to the word 'Clipboard' is a small downward pointing arrow. Click that tiny arrow.



That should open up the Clipboard pane in the Excel window. In the Clipboard pane, near the top-right corner, is a small downward pointing arrow. Click that arrow, select 'Move', and you can detach the Clipboard pane to its own floating window. Unfortunately, it's still linked to the main Excel window view: you can't show the Clipboard history window alone.

If you click the 'Options' button in the Clipboard pane, you can select 'Show Office Clipboard Icon on Taskbar'. That's the way I prefer to use the manager (when I remember it's available). If I'm working in the VBE, I just swing down to the taskbar, double-click the clipboard icon and there's the history pane.

Usage is simple. Highlight the item you want to paste, switch back to the editor and paste.


I also, can't touch type. But I can read and write cursive, which may no longer be taught in some schools.
 

spilly2010

New Member
Joined
May 12, 2018
Messages
2
You describe exactly what I want to do, but can't do in practice within the VB Editor

Unfortunately I can't paste an image

My Office clipboard does not show the text contents of clips copied from the VBE editor
They are there and can be pasted, but you can't see the text before you paste

NB I'm using Excel 2007 and that may be the issue
(just failed to install a forum tool because it doesn't work of 2007)

If I copy from Chrome, I see the text before I paste
If I copy from Excel cells, I see the text before I paste
BUT If I copy from the VBE the office clipboard window just has 3 dots, and nowt else :devilish:

I tried to describe this in my OP

gs
 

jjasmith4

New Member
Joined
Aug 22, 2018
Messages
48
In Excel 2010, when I clip a bunch of VBA code, it shows up in the Office Clipboard, but yes, I can't paste it into a code window. I tried also with Word and Access -- same thing.

I'd suggest maintaining your own spreadsheet of your favorite code snippets, which you could place either in cells on many tabs or code modules in its VBA project. Then, whenever you're working on a project open that snippet spreadsheet first, and you can then copy-and-paste to your heart's content.

At a former job of mine we took this very seriously by maintaining a global code repository of thousands of lines in hundreds of procedures, and we got to the point where just about any new project took about half the time, since we could re-use tried-and-true code to implement 60-75% of the requirements. We had separate modules, for example, for database-related stuff, system utilities, array- and collection-handling, and many others, so we could just open the repository and click-and-drag whole modules into a new project.
 

Forum statistics

Threads
1,082,247
Messages
5,364,003
Members
400,774
Latest member
Goldi paul

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top