Posted to microsoft.public.excel.programming

joel[_602_] joel[_602_] is offline

external usenet poster

Posts: 1

Populate userform spreadsheet

You need tot copy using the clip board. Direct copying doesn't seem to
work. to use the clipboard first copy then paste. Try this

Set Dest = UserForm1.Spreadsheet1.Range("a1")

Sheets("sheet1").Range("A1:B2").Copy
Dest.Paste

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=173389

Microsoft Office Help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...	PackersXLVGirl	Excel Programming	1	January 27th 12 02:59 PM
populate userform only	tkraju via OfficeKB.com	Excel Programming	1	April 17th 09 03:00 PM
Populate Spreadsheet #2 from Cell references on Spreadsheet #1	rael_lucid	Excel Programming	2	October 2nd 07 05:23 AM
Userform ... populate optionbutton from spreadsheet	VBAwannabe	Excel Programming	5	November 20th 06 11:27 PM
Userform using 3 ranges to populate.	Todd Huttenstine[_2_]	Excel Programming	1	December 13th 03 12:33 AM

All times are GMT +1. The time now is 04:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us