LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA selecting an input range of cells Colin Hayes Excel Discussion (Misc queries) 4 April 19th 10 02:17 AM
Selecting multiple cells, I can't see the cells highlighted ET Excel Discussion (Misc queries) 1 August 1st 08 03:20 PM
How to change shade of cells when selecting multiple cells abrummet Excel Discussion (Misc queries) 3 September 6th 07 11:42 AM
Setting of input cells as blue font and formula cells as black fon Sunnyskies Excel Discussion (Misc queries) 2 May 14th 07 05:27 PM
By selecting cells adjacent to cells tally sheet tom Excel Worksheet Functions 2 September 20th 06 07:09 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"