Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Input Box
I'm trying to create a VBA scenario in Excel 2003 where an Input Box appears
asking the user to type a desired cell range (e.g. A1:B6) from a specified worksheet (e.g. Sheet1) in the Input Box, and then have the values that sit in whatever cell address range the user typed in the Input Box to copy and paste to another specified worksheet (e.g. Sheet2). In other words, if the user types A1:B6 in the Input Box, the VBA will copy and paste the values in cells A1 thru B6 in sheet 1 over to sheet2 starting in cell A4. I have some of the code hammered out but am stuck. Any suggestions? Thank you. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Input Box
Rather than get them to type it in, use
Set rng = Application.Inputbox("Select range",Type:=8) which allows them to select the range with the mouse. You can then simply copy that range rng.Copy Worksheets("other").Range"A1") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "dddivers" wrote in message ... I'm trying to create a VBA scenario in Excel 2003 where an Input Box appears asking the user to type a desired cell range (e.g. A1:B6) from a specified worksheet (e.g. Sheet1) in the Input Box, and then have the values that sit in whatever cell address range the user typed in the Input Box to copy and paste to another specified worksheet (e.g. Sheet2). In other words, if the user types A1:B6 in the Input Box, the VBA will copy and paste the values in cells A1 thru B6 in sheet 1 over to sheet2 starting in cell A4. I have some of the code hammered out but am stuck. Any suggestions? Thank you. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Input Box
Fantastic! Thank you.
"Bob Phillips" wrote: Rather than get them to type it in, use Set rng = Application.Inputbox("Select range",Type:=8) which allows them to select the range with the mouse. You can then simply copy that range rng.Copy Worksheets("other").Range"A1") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "dddivers" wrote in message ... I'm trying to create a VBA scenario in Excel 2003 where an Input Box appears asking the user to type a desired cell range (e.g. A1:B6) from a specified worksheet (e.g. Sheet1) in the Input Box, and then have the values that sit in whatever cell address range the user typed in the Input Box to copy and paste to another specified worksheet (e.g. Sheet2). In other words, if the user types A1:B6 in the Input Box, the VBA will copy and paste the values in cells A1 thru B6 in sheet 1 over to sheet2 starting in cell A4. I have some of the code hammered out but am stuck. Any suggestions? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
***Two Input Data Tables*** | Excel Discussion (Misc queries) | |||
input box | Excel Discussion (Misc queries) | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) |