+ Reply to Thread
Results 1 to 6 of 6

selecting cells with an input box

  1. #1
    Jordan
    Guest

    selecting cells with an input box

    Hello,
    I have a program for which I need to have the users select the cells they
    want. Right now I am using:

    Set rCells = Application.InputBox _
    (Prompt:="Select the drawings you wish to appear on the Drawing
    Acknowledgement", _
    Title:="Create Drawing Acknowledgement", Left:=558,
    Type:=8).SpecialCells(xlCellTypeVisible)

    This works great, except that if the user clicks the start button and then
    needs to scroll down to select cells that they want, the program adds all the
    cells (starting on the first cell of the page, A1) that the user did not
    select.

    Hopefully this is a dumb error on my part, thanks,
    Jordan


  2. #2
    Bob Phillips
    Guest

    Re: selecting cells with an input box

    What start button?

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Jordan" <[email protected]> wrote in message
    news:[email protected]...
    > Hello,
    > I have a program for which I need to have the users select the cells

    they
    > want. Right now I am using:
    >
    > Set rCells = Application.InputBox _
    > (Prompt:="Select the drawings you wish to appear on the Drawing
    > Acknowledgement", _
    > Title:="Create Drawing Acknowledgement", Left:=558,
    > Type:=8).SpecialCells(xlCellTypeVisible)
    >
    > This works great, except that if the user clicks the start button and then
    > needs to scroll down to select cells that they want, the program adds all

    the
    > cells (starting on the first cell of the page, A1) that the user did not
    > select.
    >
    > Hopefully this is a dumb error on my part, thanks,
    > Jordan
    >




  3. #3
    Jordan
    Guest

    Re: selecting cells with an input box

    Sorry, I had the feeling I should have expanded on that. "Start Button"
    refers to the forms button that has my macro program assinged to it. Just a
    simple click object button.

    "Bob Phillips" wrote:

    > What start button?
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Jordan" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hello,
    > > I have a program for which I need to have the users select the cells

    > they
    > > want. Right now I am using:
    > >
    > > Set rCells = Application.InputBox _
    > > (Prompt:="Select the drawings you wish to appear on the Drawing
    > > Acknowledgement", _
    > > Title:="Create Drawing Acknowledgement", Left:=558,
    > > Type:=8).SpecialCells(xlCellTypeVisible)
    > >
    > > This works great, except that if the user clicks the start button and then
    > > needs to scroll down to select cells that they want, the program adds all

    > the
    > > cells (starting on the first cell of the page, A1) that the user did not
    > > select.
    > >
    > > Hopefully this is a dumb error on my part, thanks,
    > > Jordan
    > >

    >
    >
    >


  4. #4
    Bob Phillips
    Guest

    Re: selecting cells with an input box

    Jordan,

    In your situation, are they clicking this Start button after the input box
    is displayed? And is this Start button the one that runs the macro with the
    Inputbox? I couldn't reproduce this situation.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Jordan" <[email protected]> wrote in message
    news:[email protected]...
    > Sorry, I had the feeling I should have expanded on that. "Start Button"
    > refers to the forms button that has my macro program assinged to it. Just

    a
    > simple click object button.
    >
    > "Bob Phillips" wrote:
    >
    > > What start button?
    > >
    > > --
    > >
    > > HTH
    > >
    > > RP
    > > (remove nothere from the email address if mailing direct)
    > >
    > >
    > > "Jordan" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Hello,
    > > > I have a program for which I need to have the users select the

    cells
    > > they
    > > > want. Right now I am using:
    > > >
    > > > Set rCells = Application.InputBox _
    > > > (Prompt:="Select the drawings you wish to appear on the

    Drawing
    > > > Acknowledgement", _
    > > > Title:="Create Drawing Acknowledgement", Left:=558,
    > > > Type:=8).SpecialCells(xlCellTypeVisible)
    > > >
    > > > This works great, except that if the user clicks the start button and

    then
    > > > needs to scroll down to select cells that they want, the program adds

    all
    > > the
    > > > cells (starting on the first cell of the page, A1) that the user did

    not
    > > > select.
    > > >
    > > > Hopefully this is a dumb error on my part, thanks,
    > > > Jordan
    > > >

    > >
    > >
    > >




  5. #5
    Jordan
    Guest

    Re: selecting cells with an input box

    Good Morning Bob,

    Yes, clicking on the Start button runs the macro with the Inputbox.
    It's a really wierd deal. On on of my computers I don't even need to scroll
    down for this error to occur. I'm wondering if this might partially be a
    setting issue. Still, I don't know why it would add cells to rCells that
    wern't inputed into the input box. Any thoughts? If you like, I wouldn't
    mind sending you the workbook, it doens't have any confidential information
    or anything like that on it, so it wouldn't be a big deal on my end.

    Thanks for your help,
    Jordan

    "Bob Phillips" wrote:

    > Jordan,
    >
    > In your situation, are they clicking this Start button after the input box
    > is displayed? And is this Start button the one that runs the macro with the
    > Inputbox? I couldn't reproduce this situation.
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Jordan" <[email protected]> wrote in message
    > news:[email protected]...
    > > Sorry, I had the feeling I should have expanded on that. "Start Button"
    > > refers to the forms button that has my macro program assinged to it. Just

    > a
    > > simple click object button.
    > >
    > > "Bob Phillips" wrote:
    > >
    > > > What start button?
    > > >
    > > > --
    > > >
    > > > HTH
    > > >
    > > > RP
    > > > (remove nothere from the email address if mailing direct)
    > > >
    > > >
    > > > "Jordan" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > Hello,
    > > > > I have a program for which I need to have the users select the

    > cells
    > > > they
    > > > > want. Right now I am using:
    > > > >
    > > > > Set rCells = Application.InputBox _
    > > > > (Prompt:="Select the drawings you wish to appear on the

    > Drawing
    > > > > Acknowledgement", _
    > > > > Title:="Create Drawing Acknowledgement", Left:=558,
    > > > > Type:=8).SpecialCells(xlCellTypeVisible)
    > > > >
    > > > > This works great, except that if the user clicks the start button and

    > then
    > > > > needs to scroll down to select cells that they want, the program adds

    > all
    > > > the
    > > > > cells (starting on the first cell of the page, A1) that the user did

    > not
    > > > > select.
    > > > >
    > > > > Hopefully this is a dumb error on my part, thanks,
    > > > > Jordan
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  6. #6
    Bob Phillips
    Guest

    Re: selecting cells with an input box

    Okay send me the book, give it a subject with Excel in it and preferably
    Jordan.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Jordan" <[email protected]> wrote in message
    news:[email protected]...
    > Good Morning Bob,
    >
    > Yes, clicking on the Start button runs the macro with the Inputbox.
    > It's a really wierd deal. On on of my computers I don't even need to

    scroll
    > down for this error to occur. I'm wondering if this might partially be a
    > setting issue. Still, I don't know why it would add cells to rCells that
    > wern't inputed into the input box. Any thoughts? If you like, I wouldn't
    > mind sending you the workbook, it doens't have any confidential

    information
    > or anything like that on it, so it wouldn't be a big deal on my end.
    >
    > Thanks for your help,
    > Jordan
    >
    > "Bob Phillips" wrote:
    >
    > > Jordan,
    > >
    > > In your situation, are they clicking this Start button after the input

    box
    > > is displayed? And is this Start button the one that runs the macro with

    the
    > > Inputbox? I couldn't reproduce this situation.
    > >
    > > --
    > >
    > > HTH
    > >
    > > RP
    > > (remove nothere from the email address if mailing direct)
    > >
    > >
    > > "Jordan" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Sorry, I had the feeling I should have expanded on that. "Start

    Button"
    > > > refers to the forms button that has my macro program assinged to it.

    Just
    > > a
    > > > simple click object button.
    > > >
    > > > "Bob Phillips" wrote:
    > > >
    > > > > What start button?
    > > > >
    > > > > --
    > > > >
    > > > > HTH
    > > > >
    > > > > RP
    > > > > (remove nothere from the email address if mailing direct)
    > > > >
    > > > >
    > > > > "Jordan" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > Hello,
    > > > > > I have a program for which I need to have the users select the

    > > cells
    > > > > they
    > > > > > want. Right now I am using:
    > > > > >
    > > > > > Set rCells = Application.InputBox _
    > > > > > (Prompt:="Select the drawings you wish to appear on the

    > > Drawing
    > > > > > Acknowledgement", _
    > > > > > Title:="Create Drawing Acknowledgement", Left:=558,
    > > > > > Type:=8).SpecialCells(xlCellTypeVisible)
    > > > > >
    > > > > > This works great, except that if the user clicks the start button

    and
    > > then
    > > > > > needs to scroll down to select cells that they want, the program

    adds
    > > all
    > > > > the
    > > > > > cells (starting on the first cell of the page, A1) that the user

    did
    > > not
    > > > > > select.
    > > > > >
    > > > > > Hopefully this is a dumb error on my part, thanks,
    > > > > > Jordan
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




+ 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