MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Box and Data Form

Posted by Styve on May 10, 2001 8:49 AM


A few years ago I personalized my data forms by using the dialog editor with Excell.
Now, everything is changed! I am trying to set up a excell file to enter trading information for
each of my trades on the NASDAQ. I would like to use the regular data form to enter this data but I would like
to remove some buttons and I need two combo box in the data form.

Can I do this without programming in VBA.

Thanks for your help.


Posted by mseyf on May 10, 2001 10:43 AM

There is a non-VBA combo-box object available on the 'Control Toolbox' toolbar (View>Toolbars>Control Toolbox).



Posted by styves on May 10, 2001 11:32 AM

How do I include the combo box in the standard data form?

Posted by mseyf on May 10, 2001 3:08 PM

I'm a little confused by the term 'standard data form', but I'll give it a go. To use the combo box, click on the combo box icon on the 'Control Toolbox'so it is depressed, then draw the combo box on the form. Next, click on the Properties icon on the 'Control Toolbar' (a finger pointing to a page) to bring up the 'Properties' window. The two properties you're probably most concerned with will be 'LinkedCell' and 'ListFillRange'. 'LinkedCell' is the cell address that will receive the item selected in the combo box, and 'ListFillRange' is the range (preferably a named range) that contains the data to populate the combo box.

To test the combo box you need to toggle the 'Design Mode' icon on the Control Toolbox toolbar (looks like a blue triangle and a pencil)

You can experiment with the other properties in the properties window to get the combo box to look and behave the way you wish. (if you have any questions on an item, many of them allow you to highlight the item and press F1 for more info). You need to remember to toggle the 'Design Mode' icon to test and change the combo box.

Hope this is the info you were seeking.

Good luck


Posted by Styves on May 11, 2001 8:30 AM

What I mean by Standard Data Form is this: When you have
a table in excell and you select Form in the Data Menu, you get a window
to assisy you in entering data. I would like a combo box in this data form.