Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box
hi
i would use data validation instead. 300 combo boxes is a tad much. and data validation is cell specific. and you should be able to copy and paste in mass ie the whole column in one paste. if you are unfamilar with data validation, see this site for details. http://www.contextures.com/xlDataVal01.html regards FSt1 "CAM" wrote: Hello, I have a worksheet that contains about 300 rows in one column the user has to input an account number. This is an expense report. My problem is that the user always seems to never enter the account numberget correctly . I seems that there always short by couple of digits. So I decide that I want to put a combo box in all of the 300 rows, but the problem is how do I copy and paste 299 rows of the combo box and have it properly reflect the cell link to the proper cell in the row and stay in the cell without moving it? Later I want to copy the rows to another worksheets, but the rows may vary. Also do I have to be concern with the =Index() as well?. I am using Excel 2003. Any tips will be appreicated. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |