Results 1 to 2 of 2

VBA Inputbox

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2008
    Location
    Barrie, ON, CA
    Posts
    47

    VBA Inputbox

    I attached a small example of what im trying to do here but bear with me im just getting started in VBA... Macro2 is suppose to copy the specified range at the start of the macro then the user is suppose to point to the destination where they want it pasted with the inputbox... as you can see when you run this macro it's not quite working... just wondering if anyone could amend it for me and maybe briefly explain where im going wrong if its not too time consuming??

    Sub Macro2()
    '
    ' Macro2 Macro
    ' Macro recorded 9/26/2008 by ron.bond
    '
    ' Keyboard Shortcut: Ctrl+Shift+W
    '
        Range("A2:B34").Select
        Selection.Copy
        Set rng = Application.InputBox(prompt:="Select Range or Starting Point", Title:="Output", Type:=8)
        rng.Select
        ActiveSheet.Paste
    End Sub
    Last edited by RBI; 10-06-2008 at 09:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA inputbox
    By RBI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2008, 12:46 PM
  2. Inputbox - HELP button not displayed
    By little_pea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2008, 06:03 AM
  3. InputBox and ranges from another worksheet
    By Ruahrc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2008, 01:48 PM
  4. Dots, instead of characters in InputBox
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2007, 03:36 AM
  5. InputBox
    By grahammal in forum Excel General
    Replies: 4
    Last Post: 09-11-2007, 07:53 AM

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