Combo Box help

[imma1313]

i have a question about visual basic and i was hoping that you would help me out. i am assuming someone knows a lot about incorporating message boxes into excel 2003 for easier input and that's where my problem is. i am trying to use a combo box to help input data, but i am unsure of the coding required to create the choices for the input. i went over some visual basic stuff briefly, but we never touched upon combo boxes. i also was wanting to have certain values appear in other cells when the user selects one of the choices. the problem is that i don't know how to make it so you can choose the row from the message box. i am doing this to help someone out at work to make his life a little easier. if you could help that would be great.

[zaza]

Welcome to the Forums


Perhaps a better way to do this would be using the Validation in a cell. Make a list in a set of cells, say A1:A4. Select the cell in which you want a list, and choose Data, Validation menu. Drop the box down to List and then select your range A1:A4. Voila, you have a dropdown in that cell.

To make other cells depend on this, just use an Excel formula in the normal fashion.

See the Excel Tips and Tricks link in my sig for more...

zaza