ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is it possible to paste data into a UserForm? (https://www.excelbanter.com/excel-programming/343579-possible-paste-data-into-userform.html)

cheaperThanAPro[_12_]

Is it possible to paste data into a UserForm?
 

Well, this UserForm is becoming less and less of interest to us all the
time. This may be its death knell.

Our input people don't type the data: they copy and paste it from other
electronic sources. Is it possible to copy text from, say, an e-mail
message, and paste it into a text box on a UserForm? If so, how do I
convince the form (or text box) to allow that? I am on a Macintosh, by
the way. I've tried Command-V (the usual pasting keystroke) and nothing
happens.

If not, *please* get your act together on the Macintosh, Microsoft. If
my users can't tab between textboxes on the form *and* they can't paste
into textboxes, there's no point in the UserForms for us. It's enough
to send one to Open Office, good Mac gui or not, it really is. I know
we're the "enemy" platform, but if you're gonna develop for us,
*develop* for us!

ctap


--
cheaperThanAPro
------------------------------------------------------------------------
cheaperThanAPro's Profile: http://www.excelforum.com/member.php...o&userid=28241
View this thread: http://www.excelforum.com/showthread...hreadid=478565


Chip Pearson

Is it possible to paste data into a UserForm?
 
I don't know about a Mac, but Ctrl+v works fine to paste into a
text box under Windows.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"cheaperThanAPro"
<cheaperThanAPro.1xd1ma_1130079917.9997@excelfor um-nospam.com
wrote in message
news:cheaperThanAPro.1xd1ma_1130079917.9997@excelf orum-nospam.com...

Well, this UserForm is becoming less and less of interest to us
all the
time. This may be its death knell.

Our input people don't type the data: they copy and paste it
from other
electronic sources. Is it possible to copy text from, say, an
e-mail
message, and paste it into a text box on a UserForm? If so,
how do I
convince the form (or text box) to allow that? I am on a
Macintosh, by
the way. I've tried Command-V (the usual pasting keystroke)
and nothing
happens.

If not, *please* get your act together on the Macintosh,
Microsoft. If
my users can't tab between textboxes on the form *and* they
can't paste
into textboxes, there's no point in the UserForms for us. It's
enough
to send one to Open Office, good Mac gui or not, it really is.
I know
we're the "enemy" platform, but if you're gonna develop for us,
*develop* for us!

ctap


--
cheaperThanAPro
------------------------------------------------------------------------
cheaperThanAPro's Profile:
http://www.excelforum.com/member.php...o&userid=28241
View this thread:
http://www.excelforum.com/showthread...hreadid=478565




cheaperThanAPro[_13_]

Is it possible to paste data into a UserForm?
 

I need to know if there's any way to do it on the Mac.


--
cheaperThanAPro
------------------------------------------------------------------------
cheaperThanAPro's Profile: http://www.excelforum.com/member.php...o&userid=28241
View this thread: http://www.excelforum.com/showthread...hreadid=478565


Tom Ogilvy

Is it possible to paste data into a UserForm?
 
news://msnews.microsoft.com/microsof...c.office.excel

Might be a better place to ask.

--
regards,
Tom Ogilvy

"cheaperThanAPro"
<cheaperThanAPro.1xd76b_1130087105.6552@excelfor um-nospam.com wrote in
message news:cheaperThanAPro.1xd76b_1130087105.6552@excelf orum-nospam.com...

I need to know if there's any way to do it on the Mac.


--
cheaperThanAPro
------------------------------------------------------------------------
cheaperThanAPro's Profile:

http://www.excelforum.com/member.php...o&userid=28241
View this thread: http://www.excelforum.com/showthread...hreadid=478565




cheaperThanAPro[_14_]

Is it possible to paste data into a UserForm?
 

I am so amazingly dim that I didn't even catch what you were suggesting.
Hours of VB programming must've blunted my wits!

What's more, Ctrl-V *works* to paste on the Mac, too! Oh, happy day!

Thanks so much, and again my apologies for massive obtuseness.

ctap


--
cheaperThanAPro
------------------------------------------------------------------------
cheaperThanAPro's Profile: http://www.excelforum.com/member.php...o&userid=28241
View this thread: http://www.excelforum.com/showthread...hreadid=478565



All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com