I created a combo box (Active X) in cell A1. How do I copy it down to A2 through A500 to create a form for users to input data?
On a side note:
After I have selected the value from the combo box drop down and then press the TAB key on the keyboard the active cell does not move to the next cell to the right. I have to click the cell with the mouse. How can I enable the TAB behavior?