Label Controls Developer Tab

Are you trying to make a Data Form like the very first picture (grey window with fields for Customer ID, Customer Name, etc.)?

If so, search Excel's helpf for "Add, edit, find, and delete rows by using a **data** **form**"

If you are talking about the first picture in the table of controls titled "Summary of form controls", then I think those boxes next to the Label controls are actual worksheet cells, since Text Field controls "are unavailable in Office Excel 2007 workbooks".

Exactly what is it that you are trying to do?

Cheers

Rich

It was that first photo in the table on controls. And those don't look like cells to me they are inserted shape rectangles.

I still don't have a clue on label and active x controls. There should be a drawing canvas in Excel and seperate from a worksheet. The worksheet is the worksheet. Microsoft messed up.

If you are talking about the first picture with a blue background under Summary of Form Controls, with the text "Identifies the purpose of acell or text box, or displays descriptive text (such as titles, captions, pictures) or brief instructions."... it is quite easy to make cells look like that.  Just give the cells a border and turn off gridlines (in the View tab, Show/Hide group).

As the text says, the label identifies the purpose of a cell or text box.  Either use cells on the worksheet, or draw a textbox using Insert > Shape.

(You could just as easily use another cell for the label, then protect the sheet to control which cells are editable).

You still haven't said what it is that you are trying to do?

I'm trying to practice on building a simple form in Excel using these labels and other controls on that developer tab in the ribbon. You have about twenty different form and active x controls. I am also trying to get this concept down for the Excel Expert exam in 2007 because I feel it could come up as something.

Why is the Microsoft Excel help in this area referring to a drawing canvas? There is adrawing contextual tab I know but no drawing canvas in Excel. And also the worksheet is the worksheet. If you remove the gridlines its still a spreadsheet.