+ Reply to Thread
Results 1 to 2 of 2

Copy and Paste Value from Input box

Hybrid View

srikanthbenoni Copy and Paste Value from... 05-17-2012, 11:07 AM
JapanDave Re: Copy and Paste Value from... 05-17-2012, 12:05 PM
  1. #1
    Registered User
    Join Date
    02-14-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    22

    Copy and Paste Value from Input box

    Hi All,

    I have created a Macro to paste the values in Col A until it finds a value in Col B, but this code some what does not work, can someone rectify it.

    Thanks,
    Ben

    Option Explicit 
     
    Sub test() 
        Dim Eingabe As String 
        Dim Rw As Long 
         
        Rw = Cells(Rows.Count, 1).End(xlUp).Row 
        Do Until Not IsEmpty(Cells(Rw, 3).End(xlUp)) 
            Eingabe = InputBox("Enter a number") 
            Cells(Rw, 1).Value = Eingabe 
            Rw = Rw + 1 
        Loop 
    End Sub

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Copy and Paste Value from Input box

    I have no idea what you are doing, but this is what I can gather from your post that you want.

    Option Explicit
     
    Sub test()
        Dim c02, c01
        
        c01 = Cells(Rows.Count, 1).End(xlUp).Row
        
            Do Until Cells(c01 - 1, 2).Value <> ""
                c02 = InputBox("Enter a number")
                Cells(c01 + 1, 1).Value = c02
                c01 = c01 + 1
            Loop
    End Sub
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1