Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 3rd, 2014, 12:19 AM
Registered User
 
Join Date: Jan 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Pasting values

Hi All

I am new to this forum, Just joined today.
My knowledge about excel and programming is at a very nascent
stage. Hopefully i would be develop that with help from
the contributors,forum members on this site.

My query : I Want a vba code where a user can only paste values
the values are copied from a different software where they will
do a ctrl + c on a number and then paste it in the cells.

for example there is a number 123456 they copy that paste it in c1
and the next number in c2 and so on.

*basically i want to restrict the user typing into these cells but only paste values. hence i think something needs to be done in VBA

Many thanx

Last edited by grkchakri; January 3rd, 2014 at 12:27 AM..





Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting data from clipboard rahesh Visual Basic 2005 Basics 0 May 23rd, 2008 12:40 PM
Pasting into spreadsheets IainAL VB How-To 0 April 23rd, 2007 04:33 AM
Copy and Pasting jilly Beginning VB 6 1 March 8th, 2006 09:46 AM
easy pasting problem reverand Excel VBA 17 November 25th, 2005 01:11 AM
Copieng and pasting with VBA vorax187 Access VBA 2 October 13th, 2005 11:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.