Results 1 to 7 of 7

Input box not allowing mouse clicks

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-16-2004
    Location
    Devon UK
    MS-Off Ver
    2010
    Posts
    357

    Input box not allowing mouse clicks

    Sorry about this I am asking a lot of questions about code not working with excel 2010

    I have the code below which displays an input box asking the user to select a destination row. When used with office 2003 you could click on any row and the range was automatically filled in on the userform. When using this code on excel 2010 the userform is displayed ok but whilst the form is visible no mouse clicks (outside of the form) are accepted.
    Is there a way I can modify this or if not an alternate way of the user selecting a row without having to type in its address?

     Prompt = "Select the destination Row."
        title = "Select a cell"
    
    '   Display the Input Box
        On Error Resume Next
        Set UserRange = Application.InputBox( _
            Prompt:=Prompt, _
            title:=title, _
            Default:=ActiveCell.Address, _
            Type:=8) 'Range selection
    
    '   Was the Input Box canceled?
        If UserRange Is Nothing Then
            MsgBox "Cancelled."
    Last edited by tryer; 05-01-2011 at 02:05 AM.

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