Combo Box and Data Form

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

HTH

Mark

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

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

Mark

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.

Styves