
September 10th, 2003, 10:04 AM
|
|
Junior Member
|
|
Join Date: Sep 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
adding combo box, macro code
Hi! I have a question about adding combo boxes in excel. I have created a spreadsheet and want to have certain every cell in certain columns have a combo box that will pop up when the cell is selected and provide a list of values to chose from. I have created this spreadsheet in access successfully but cannot figure it out in excel. Coudl someone tell me what the macro code is.
i.e. in access I selected design mode, combo box, value list, and then typed in "one";"two". What is the pathway to achieve this in excel. Thanks so much!
|