Clipboard for Unicode and Non-Unicode

Hi all,

We have a progarm write with non-unicode. I found that in some
language, the character can not be pasted to CEdit correctly. For
example, if our application is running on Russian XP, the string copy
from IE can be pasted to CEdit properly. But if I pasted the same
string into Notepad, and then copy the string from notepad to our
CEdit, the string can not show corectly. Is it a coding problem? Is it
possible to make CEdit to accept the string from notepad?

Thanks,
Justin
0
ccfang (12)
11/20/2007 10:05:57 AM
vc.mfc 33608 articles. 0 followers. Follow

14 Replies
1246 Views

Similar Articles

[PageSpeed] 8

If it is a question of pasting a UTF16 string into a single-byte edit 
control, you could try it in two stages:

LPCWSTR pszString = ...;
CString string( pszString );
EditControl.SetWindowText( string );

This should work both in unicode and non-unicode apps.

Dave
-- 
David Webber
Author of 'Mozart the Music Processor'
http://www.mozart.co.uk
For discussion/support see
http://www.mozart.co.uk/mozartists/mailinglist.htm



"Justin_Fang" <ccfang@gmail.com> wrote in message 
news:7f3f40e2-f233-4218-92fd-d7f8f6198277@b40g2000prf.googlegroups.com...
> Hi all,
>
> We have a progarm write with non-unicode. I found that in some
> language, the character can not be pasted to CEdit correctly. For
> example, if our application is running on Russian XP, the string copy
> from IE can be pasted to CEdit properly. But if I pasted the same
> string into Notepad, and then copy the string from notepad to our
> CEdit, the string can not show corectly. Is it a coding problem? Is it
> possible to make CEdit to accept the string from notepad?
>
> Thanks,
> Justin 

0
dave9996 (486)
11/20/2007 4:01:46 PM
"Justin_Fang" <ccfang@gmail.com> wrote in message 
news:7f3f40e2-f233-4218-92fd-d7f8f6198277@b40g2000prf.googlegroups.com...
> Hi all,
>
> We have a progarm write with non-unicode. I found that in some
> language, the character can not be pasted to CEdit correctly. For
> example, if our application is running on Russian XP, the string copy
> from IE can be pasted to CEdit properly. But if I pasted the same
> string into Notepad, and then copy the string from notepad to our
> CEdit, the string can not show corectly. Is it a coding problem? Is it
> possible to make CEdit to accept the string from notepad?
>

Apparently IE copies the string in CF_UNICODETEXT format so that it appears 
properly in Notepad.  But Notepad copies it in CF_TEXT format, so CEdit 
pastes the Ansi string which doesn't show properly.  Very strange.  You 
could verify this by verifying the clipboard formats.  There was an app 
called clpviewer.exe or something like that in the past?

-- David


0
dc2983 (3206)
11/20/2007 5:11:39 PM
If you store it as CF_UNICODE, any attempt to paste it into an 8-bit app will do a
WideCharToMultiByte to convert it down.  If there are characters in the representation
that won't down-convert, they will come out as something incorrect.  If you store it as
CF_TEXT, and paste it into Unicode, there will be a MultiByteToWideChar to convert it to
Unicode.  Generally, if you want to be certain, you should put CF_UNICODE first into the
clipboard and follow it by CF_TEXT (perhaps converted according to a Russian codepage), in
which case you would be running in a Russian locale setting.

That's sort of the best advice I have so far.
					joe

On Tue, 20 Nov 2007 02:05:57 -0800 (PST), Justin_Fang <ccfang@gmail.com> wrote:

>Hi all,
>
>We have a progarm write with non-unicode. I found that in some
>language, the character can not be pasted to CEdit correctly. For
>example, if our application is running on Russian XP, the string copy
>from IE can be pasted to CEdit properly. But if I pasted the same
>string into Notepad, and then copy the string from notepad to our
>CEdit, the string can not show corectly. Is it a coding problem? Is it
>possible to make CEdit to accept the string from notepad?
>
>Thanks,
>Justin
Joseph M. Newcomer [MVP]
email: newcomer@flounder.com
Web: http://www.flounder.com
MVP Tips: http://www.flounder.com/mvp_tips.htm
0
newcomer (15972)
11/20/2007 7:20:47 PM
"David Ching" <dc@remove-this.dcsoft.com> wrote in
news:SAE0j.239$4q5.217@nlpi069.nbdc.sbc.com: 

> "Justin_Fang" <ccfang@gmail.com> wrote in message 
> news:7f3f40e2-f233-4218-92fd-d7f8f6198277@b40g2000prf.googlegroups.com.
> .. 
>> Hi all,
>>
>> We have a progarm write with non-unicode. I found that in some
>> language, the character can not be pasted to CEdit correctly. For
>> example, if our application is running on Russian XP, the string copy
>> from IE can be pasted to CEdit properly. But if I pasted the same
>> string into Notepad, and then copy the string from notepad to our
>> CEdit, the string can not show corectly. Is it a coding problem? Is
>> it possible to make CEdit to accept the string from notepad?
>>
> 
> Apparently IE copies the string in CF_UNICODETEXT format so that it
> appears properly in Notepad.  But Notepad copies it in CF_TEXT format,
> so CEdit pastes the Ansi string which doesn't show properly.  Very
> strange.  You could verify this by verifying the clipboard formats. 
> There was an app called clpviewer.exe or something like that in the
> past? 

'clipbrd.exe' (Clipbook Viewer) It lives in <windir>\system32. (At least on 
my XP machine it does)

Dave Connet
0
connet1 (33)
11/21/2007 6:38:15 AM
> Generally, if you want to be certain, you should put CF_UNICODE first into 
the
> clipboard and follow it by CF_TEXT (perhaps converted according to a 
Russian codepage), in
> which case you would be running in a Russian locale setting.


Automated conversion happens between CF_TEXT, CF_OEMTEXT, CF_UNICODETEXT:
"The system implicitly converts data between certain clipboard formats: if a 
window requests data in a format that is not on the clipboard, the system 
converts an available format to the requested format. The system can convert 
data as indicated in the following table."
(http://msdn2.microsoft.com/en-
us/library/ms649013.aspx#_win32_Synthesized_Clipboard_Formats)


-- 
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
0
11/22/2007 3:48:46 AM
So, it seems that the edit control in non-unicode program has problem
if the data in clipboard has no CF_TEXT format.
Is there any workaround for this issue?


0
ccfang (12)
11/22/2007 3:49:58 AM
> We have a progarm write with non-unicode. I found that in some
> language, the character can not be pasted to CEdit correctly. For
> example, if our application is running on Russian XP, the string copy
> from IE can be pasted to CEdit properly. But if I pasted the same
> string into Notepad, and then copy the string from notepad to our
> CEdit, the string can not show corectly. Is it a coding problem? Is it
> possible to make CEdit to accept the string from notepad?

What language is the text that you try pasting in Russian?
"in some language" is not enough info.
If you are non-Unicode and try pasting text outside the ANSI code
page, that is to be expected.

Is that really a CEdit, or a CRichEdit?
That would be the only explanation (Notepad puts in the clipboard
CF_TEXT, CF_UNICODETEXT, CF_OEMTEXT, CF_LOCALE, but IE also adds
DataObject, Ole Private Data, Rich Text Format, HTML Format)



-- 
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
0
11/22/2007 3:55:43 AM
> So, it seems that the edit control in non-unicode program has problem
> if the data in clipboard has no CF_TEXT format.
> Is there any workaround for this issue?

Unicode.
But there is something else going on.
If there is CF_UNICODETEXT (and I know it is), then there is also 
CF_TEXT and CF_OEMTEXT (see my other post).

Do you let the CEdit do it's own thing, or you are trying to take
control and do something more advanced?


-- 
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
0
11/22/2007 4:03:27 AM
I just write a non-unicode MFC program (Dialog base) in Russian XP
system and add a text control(CEdit) on it.
CEdit can not show character correctly if I paste Russian string copy
from notepad.
The string "My Computer" on desktop has the same problem.

BTW, in Japanese, I can not paste any string, even the string is
copied from IE.
I need to add following line in rc. And then the behavior of Japanese
and Russian will be the same.
CONTROL    "",-1,"NativeFontCtl",NFS_EDIT|NFS_LISTCOMBO,0,0,0,0
Please refer to http://msdn2.microsoft.com/en-us/library/bb775454.aspx

Thanks
0
ccfang (12)
11/22/2007 5:52:51 AM
My suspicion is that the text is placed in the clipboard as Unicode text only.  This would
be a NotePad issue.  As already suggested, use the clipboard viewer to see what formats
are actually in the clipboard.  It would help us figure out what is going on.
					joe

On Wed, 21 Nov 2007 21:52:51 -0800 (PST), Justin_Fang <ccfang@gmail.com> wrote:

>I just write a non-unicode MFC program (Dialog base) in Russian XP
>system and add a text control(CEdit) on it.
>CEdit can not show character correctly if I paste Russian string copy
>from notepad.
>The string "My Computer" on desktop has the same problem.
>
>BTW, in Japanese, I can not paste any string, even the string is
>copied from IE.
>I need to add following line in rc. And then the behavior of Japanese
>and Russian will be the same.
>CONTROL    "",-1,"NativeFontCtl",NFS_EDIT|NFS_LISTCOMBO,0,0,0,0
>Please refer to http://msdn2.microsoft.com/en-us/library/bb775454.aspx
>
>Thanks
Joseph M. Newcomer [MVP]
email: newcomer@flounder.com
Web: http://www.flounder.com
MVP Tips: http://www.flounder.com/mvp_tips.htm
0
newcomer (15972)
11/22/2007 6:56:43 AM
> I just write a non-unicode MFC program (Dialog base) in Russian XP
> system and add a text control(CEdit) on it.
> CEdit can not show character correctly if I paste Russian string copy
> from notepad.

Tried it and works fine.

The Russian XP system has the system code page set to Russian?
("Control Panel" - "Regional Options" - tab 3, "Advanced"
the option "Language for non-Unicode programs")



-- 
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
0
11/23/2007 8:45:48 AM
> My suspicion is that the text is placed in the clipboard as Unicode
> text only.
Tried it, and notepad puts in clipboard CF_TEXT, CF_UNICODETEXT, CF_OEMTEXT, 
CF_LOCALE. Plus that there is really no way to put one of these forms
only, because the others are automatically generated. Try it.



-- 
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
0
11/23/2007 8:47:14 AM
That's good to know.  Since it always did the right thing for me, I hadn't looked at it in
years.  

As far as the "automatic", could it be that all of these are "virtual" representations,
and the representation is only generated "on demand"?  Rather than have four different
copies, it is easy to imagine that what the clipboard does is store one format and convert
to the others on demand (it would, of course, be completely transparent to the user what
had happened).

I suspect what you point out, that the wrong code page is in effect.
						joe

On Fri, 23 Nov 2007 00:47:14 -0800, "Mihai N." <nmihai_year_2000@yahoo.com> wrote:

>> My suspicion is that the text is placed in the clipboard as Unicode
>> text only.
>Tried it, and notepad puts in clipboard CF_TEXT, CF_UNICODETEXT, CF_OEMTEXT, 
>CF_LOCALE. Plus that there is really no way to put one of these forms
>only, because the others are automatically generated. Try it.
Joseph M. Newcomer [MVP]
email: newcomer@flounder.com
Web: http://www.flounder.com
MVP Tips: http://www.flounder.com/mvp_tips.htm
0
newcomer (15972)
11/23/2007 3:25:24 PM
> As far as the "automatic", could it be that all of these are "virtual"
> representations,
....
> to the others on demand (it would, of course, be completely transparent

Very possible.
In fact, the documentation says the conversion happens when you call 
GetClipboardData. But in the end it does not matter, it all behaves
"as if" all 3 formats are there.


-- 
Mihai Nita [Microsoft MVP, Windows - SDK]
http://www.mihai-nita.net
------------------------------------------
Replace _year_ with _ to get the real email
0
11/24/2007 8:36:05 AM
Reply:

Similar Artilces:

Problem linking DAO with MFC and Unicode
I am using the MFC DAO classes CDaoDatabase and CDaoRecordset to read from an Excel file. This works ok when I compile and link without the _UNICODE defined. However, when I build the project with Unicode I get the link error "error LNK2019: unresolved external symbol" I am guessing that there is a Unicode version of a library that I need to have, or need to specifically point the linker to, but I have no idea what it is. I would appreciate any help on this Thanks Carlo ...

Outlook 2000 matching a non-existent name
I seem to have "confused" the Contacts folder of Outlook 2000 on Windows XP Pro. (No Exchange server in the picture.) I used Outlook's "Add to Contacts" feature to put someone (let's call him jbrown@whatever.com) on my address list. Since I didn't know his first name, he went on as "Jbrown". Later, I wanted to add the first name, John. I can't remember whether I changed the existing record, or added a new record or deleted the old one. Either way, my Contacts folder looked OK -- "John Brown" appeared as an entry, with jbrown@whateve...

How do I access clipboard?
I just got a message telling me I have a lot of data on my clipboard - what is the clipboard and how do I access it? The clipboard is the area of memory that Windows sticks something you have copied (usually to paste elsewhere). When you close Word or the document, it asks if you have finished with the stuff on the clipboard before it clears it out. Unless you intend to copy something to paste into another application and you are closing Word before pasting into the other application, it is safe to dump it. -- Terry Farrell - MSWord MVP "dukester" <dukester@d...

non-stop outlook mail alert
i have outlook 98 and the problem is the mail alert keeps popping up even though when i check my inbox there is no new mails... what could be the problem ...

Auto Answering and Clearing the Clipboard
I am copying data from one sheet, closing it, pasting it to another, then opening a new sheet, copying data, and pasting it again to the other sheet...this goes on 21 times so that 21 pastes are pasted to one spreadsheet from 21 different files. Everytime I run the macro that does this I get a message that asks if I want to save it to the clipboard, I naturally have to answer yes... Is there a way, within the macro, that the answer can be done automatically, and also is there a way to clear out the clipboard for memory purposes all in VBA? Thanks! Application.DisplayAlerts = False ...

Non-Plug&Play driver installation
Hello there, I have a device which is not plug-&-play, but more a virtual hardware. I can install it using the Device-Manager --> Add legacy hardware, but I want to install it programmatically, eg. the use of the function SetupCopyOEMInf for plug-&-play devices. can anybody help me with this? Thanks in advance KW Is it a root enumerated device? If so, devcon is a good start (source and binaries in the WDK), the "install" switch will create a new root enumerated device and register your INF: devcon install myinf.inf ROOT\MadeUpHardwareId -scot...

Non-stop LDAP queries from Exchange server 2003
Hi, I have a problem with my exchange server 2003. It is making the same LDAP queries to my DC server at a rate of >1000 LDAP queries per second. My DC server has enough power to handle the load, but this has to stop soon. I have used packet sniffer to look at the traffic. Every query ask for the same info. The DC replies also give same answer. In Attribute: cn, the value is: public folder store. I have tried dismounting the public folder; and the queries stopped. Has you seen this problem before? Can you give me any suggestions? I can provide the sniffed packets for investigation. ...

Clipboard
Hi, I am writing a program that uses a lot of color definitions, so I have built another "color-picker" program where you can click on a color and its RGB values will be known. This all works fine, although I want the text for the RGB macro to be copied to the clipboard when I click on a color, e.g. "RGB(192, 192, 192)" should be placed on the clipboard when I click on the gray area of the window so I can then paste it. I have got a CString to hold this value, however I can't get it into the clipboard. Whatever combination of the memory mapping functions I try ...

Error Message: Cannot Empty the Clipboard
In Excel 2003, when I copy cells, I receive an error message that says "Cannot Empty the Clipboard" and am unable to paste the cells into any other application (e.g. Word). The clipboard appears to remain empty, though I am able to paste the contents of the copies to a different location in the same worksheet. Any thoughts on what the problem is or how to fix it? ...

Blocking Clipboard
I tried to search a bit and could not find anything on this. Has anyone else noticed behavior in which Outlook apparently empties the clipboard when a something new is opened? Here's an example i can reproduce at will: 1. In a mail message, copy some text to the clipboard. 2. Open a new contact. 3. Paste the copied text into the new contact memo field. Whenever I do this, nothing pastes. The clipboard is empty. If you switch steps 1 and 2, it works just fine. I am using Outlook 2003. I do not use the MSO multiple clipboard. Thanks. Perhaps it is an add-in for contacts installed whic...

SendMessage TTM_ADDTOOL fails when Unicode
Anyone knows of any possible situation where SendMessage/TTM_ADDTOOL fails under Unicode? And that too only with VC++ 7.1. It does not fail under VC++ 6 file - tooltip.cpp func - void CWnd::FilterToolTipMessage(MSG* pMsg) line - VERIFY(pToolTip->SendMessage(TTM_ADDTOOL, 0, (LPARAM)&ti)); What could have changed in from VC 6 to VC 7.1? Thanks in advance for any pointers. -- Regards, Nish [VC++ MVP] http://www.voidnish.com http://blog.voidnish.com Ok - I figured out why it worked in VC6 and not in VC7.1 In VC6, _WIN32_WINNT is defined to an older version and thus the TOOLINFO ...

How can I access the windows clipboard?
On closing a number of applications ask if I want to keep the data on my clipboard available for other applications. How can I look at the clipboard, either before or after closing down, to see what is available to me there? The Windows clipboard will contain the last thing you copied. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< >...

Excel
Excel is the only application that I use in Windows that wipes out the clipboard after I paste. I often need to past the same information multiple times and I wishthere was an option box that allowed me to keep the clipboard after every past ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree&quo...

Money 2003 restore backup asking for a non existent password
I have microsoft money 2003 at my work and wanted to have the same data there in my home. So i made a backup, put on a pendrive and brought it to home. Installed microsoft money 2003 in my home and tried to restore this backup. Money 2003 insists asking a password that does not exist in the original backup file. I already tried to use the repair tool and didn't work. So, what i have to do to make the backup work and does not ask a password that does not exists? Thank you Calil, This newsgroup deals with Microsoft Access, a relational database application. You'll have bette...

Clipboard gets empty by itself, cleared clipboard, copy paste doesn't work, outlook clears clipboard, problems with clipboard
(subject is filled with keywords so others can find this message. here some additional keywords in german: leere zwischenablage entleert sich kopieren einf�gen kein text mehr da zwischenablage verschwindet) I've spent many hours and days(!) to find the reason why my clipboard gets empty by itself. Sometimes it took few seconds, sometimes some minutes. I was unable to do my work as software developer for weeks in a reasonable way! Now I've found the reason: It was Cloudmark Desktop! http://www.cloudmark.com/desktop/releasenotes/ "Copy and Paste functionality - Fixed a problem wh...

How do I include non working time in duration?
Hi I am setting up a project and in the duration column I want to show the total number of days required for the project including non working days - i.e if a task takes 6 days and starts on a Monday, if Sat and Sun are non working the task is finished on the following Monday but has taken 8 days to complete (including non working time).... Does anyone know how i can show this? Tks Maryfr, You could insert a custom field (Text or Number, with the formula: DateDiff("d";[Start];[Finish]) But this DateDiff function rounds down to the lowest entire number. G�rard Du...

Where is My Clipboard Data!?!
I've Invested a Lot of Time & Effort working up a List of Stock Paragraphs on the Office clipboard. I used these Clips Many, many times a Day: What did you Do with My DATA!!!! I've 'Downgraded' to Office 2004 and hate it � I can't do a Damn thing with it and wish I Hadn't NOW!!! What Must I Do to Recover My Livelihood? The Office Assistant is No help: when I type Clipboard that Stupid Mac/SE (Where is my beloved Cat 'Scribble'? ANOTHER Damn Downgrade) refers me to a 'Scrapbook' (And IT'S EMPTY!!). Where's ALL My Data, Microsoft?!? -- ...

SOT
This is a multi-part message in MIME format. ------=_NextPart_000_012F_01C55179.E34527A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it possible to use non-Exchange Mail servers with Outlook (I'm = thinking of the free Mercury that comes from Pegasus initially - are = there others?) and if so, are there any recommended web sites to tell me = both how to set up the mail server and also connect Outlook to it? Thanks --=20 Gordon Burgess-Parker Interim Systems and Management Accounting www.gbpcomputing.co.uk ------=_NextPart_000...

Copy / Paste Function & the Office Clipboard #2
Excel 2003 When I copy in Excel, I am able to paste via CTRL-V or the paste tool only so long as the copied item maintains a "moving border" (i.e., the cell is bounded by a running dotted border). Other than recopying the cell, is utilizing the Office Clipboard the only way to continue to paste after the moving border is "turned off?" TIA Karen ...

To find equation for two sets of non contiguous data
Hi I have data like this: Q C Q C Q c Formula (or equation) a 1 10 2 20 3 30 b 4 40 5 50 6 60 I want a relation like y =m x or y= 3*e 0.2 ., or somethign liek that, like how we get aan equation when we add a trend line. Is it possible to get the equation for the above arranged data, and when i drag it to the next row of data can the equation be updated using some trend formula or something... IS this possible If you want function that relates Q and C, it would appear to be C = 10*Q or Q = C/10 If you are asking whether those coefficients could be calculated b...

Clipboard
Don't know if this is a Windows or Corel problem, but since I replaced dead computer and reinstalled WP OFFICE 11 (WIN XP) cannot copy (or cut) to clipboard. Couldn't find anything in Help topics for either XP or Corel about a problem with the clipboard, just how to use it. Any help woujld be apreciated Thank you Walking man Probably not a hardware issue. You might want to be posting to windowsXP.general instead. (I've crossposted this reply) Do you get any errors? Does copy work outside Corel or Office, as in Notepad or WordPad? Can you see anything in Clipbrd (clipb...

How do I find non-ASCII characters hidden in text?
I am trying to post a large amount of Word-created text into an online form which will not accept it because it contains non-ASCII characters. I cannot see any. There is a lot of text to retype. How do I find the non-ASCII characters? Try saving the Word file as text (.txt), then copying from that. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "MizQ" <MizQ@discussions.microsoft.com> wrote in message news:C225661E-E7CA-4035-B999-A479B5DF5A5A@microsoft.com... >I am trying to post a large amount ...

How to display HTML HELP from VC++ when compiling for WIN64/Unicode
Hi all, My first post to this group, please be nice :-) I'm migrating my Visual Studio 6 C++ (MFC) projects to Visual Studio 2005. In my projects I launch HTML Help using the following notation: ::HtmlHelp(0, NULL, HH_DISPLAY_TEXT_POPUP, (DWORD)&popup); having previously declared HH_POPUP popup; In some case I instead use: ::HtmlHelp(0, cHelpFilePath:"::/changetimestamp.htm", HH_DISPLAY_TOPIC, NULL); This all works fine in VS2005 too, no problem. EXCEPT....when I compile for WIN64 and Unidocde! When I compile for WIN64 (x64) I get the following error: TipDlg.obj:...

From CString to int with Unicode
I have a CString with a numeric string in it. In the past, I would use atoi( ) to convert to an int. That doesn't work with Unicode though. What is the proper Unicode method for converting a CString to an integer? -- - Burt Johnson MindStorm, Inc. http://www.mindstorm-inc.com/software.html > What is the proper Unicode method for converting a CString to an > integer? wcstol(), for example... -- Guido Stercken-Sorrenti MVP - Visual Developer / Visual C++ Guido Stercken-Sorrenti [MVP VC++] <mspbn@stercken-sorrenti.nospam.com> wrote: > > What is the proper Un...

Clipboard
Subject: CLIPBOARD From: "Flkulchar" <flk2575@comcast.net> Sent: 1/27/2004 9:18:02 PM Please.. how can I show the contents of the clipboard within the contents of the spreadsheet... a window which pops up within the boundaries of the spreadsheet... and NOT IN THE TASK PANE. You know what I mean...that small "horizontal" window which contains the copied 'cells' on the clipboard. Thanks, Larry .. See if Chip Pearson't page is of any use to you, it is macro coding. http://www.cpearson.com/excel/clipboar.htm --- HTH, David McRitchi...