Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA selecting an input range of cells | Excel Discussion (Misc queries) | |||
Selecting multiple cells, I can't see the cells highlighted | Excel Discussion (Misc queries) | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions |