Consulting

Results 1 to 4 of 4

Thread: return cursor for manual cell selection in excel vb macro

  1. #1

    return cursor for manual cell selection in excel vb macro

    Any clues on a method to return the cursor during the execution of a vb macro for manual selection of a cell the location of which can then be fed back into the macro

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Quote Originally Posted by rodney_malod
    Any clues on a method to return the cursor during the execution of a vb macro for manual selection of a cell the location of which can then be fed back into the macro
    ACtivecell.Address

    perhaps

  3. #3
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    You could show a userform with a RefEdit control
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  4. #4
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    You could try Application.Inputbox.

Posting Permissions

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