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

selecting cells with an input box
 

What start button?

--

HTH

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


"Jordan" wrote in message
...
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

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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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