Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Copy range of cells based on Combobox Selection
Based on a user selection in a combo box, Is it possible to copy a rang
of cells from sheet1 and move them to another sheet2 Not really sure how to tackle this? Thanks for any help I can get, Greatly appreciated -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Copy range of cells based on Combobox Selection
You can copy the values very quickly with code like
Worksheets("Sheet1").Range("A1:A10").Copy _ Destination:=Worksheets("Sheet2").Range("A1") I'm not sure how your combobox fits in to this. You'll need to supply more details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel-erate2004 " wrote in message ... Based on a user selection in a combo box, Is it possible to copy a range of cells from sheet1 and move them to another sheet2 Not really sure how to tackle this? Thanks for any help I can get, Greatly appreciated! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Copy range of cells based on Combobox Selection
Further elaboration:
I have a combo box that looks up a list with 29 objects through dat validation. This is located on a sheet called species list with range A2:A30. The combo box is located on a sheet called Step 2 C5. I would like the user to be able to select a specific object from tha list and automatically copy whats in the cells on a sheet calle 'dscombo'!C11:C20:G19 and paste the values from those cells into sheet called 'Step 2'!C11:C20:G19. The key point that I should make is that the range of cells to b copied and pasted will vary depending on what object is selected fro my combo box. In the range described above that I want copied and pasted, the use would have selected the first object from the list in my combo box. I hope this helps explain my question. Thank -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 VBA Range selection based on system date | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
How do I copy a LARGE selection of cells from Excel to powerpoint? | Excel Discussion (Misc queries) | |||
Syntax - Add Range Name based on Selection | Excel Programming |