Combo box for 97

T

Tia

I am having a difficult time trying to find out how you put a combo box in
using excel 97. I also want the box attached to a cell. I'm a novice at
excel.

Thanks,
Tia
 
S

Shane Devenshire

Hi,

The easiest way is to choose View, Toolbars, Forms. Then click the combo
box tool and click or drag in the spreadsheet. To attach its results to a
cell, right-click it choose Format Control, click the Control tab and set a
link cell (where you want the results) and Input range (where you list the
items you want displayed in the combo box)

If this helps, please click the Yes button

cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup on a combo box 1
How do I create a combo box that is tied to another combo box? 2
How do I Keep a Combo Box "Focused" on difrferent cells. 5
Combo Box 7
Validation rule for Combo Box 0
Combo box? 4
Combo Box properties problem 2
Linking to combo box selection 2

Top