Label Controls Developer Tab

Anonymous
2012-03-21T15:55:50+00:00

Is there anything that might help me with label controls in Excel 2007 from the Developer Tab? You have Form and Active X Label controls. Where would it be in Excel 2007 Inside Out?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

42 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2012-03-23T18:18:17+00:00

    The same set of contols is shown when working with UserForms (VBA).  In Excel, for a textbox, just use a normal Text Box from Insert > Shapes....

    How did you get on making the ActiveX ListBox??

    [EDIT: Actually, after reading more of this post: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/textbox-text-field-from-form-controls-not/ce9793b0-b4bf-415e-a8c3-a3963e0f5841 I think I may be wrong about that.  It appears to be a mystery why they are greyed-out.  Take a look at this page, might help you more: http://www.ozgrid.com/Excel/Excel-controls-forms-toolbox.htm ]

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-03-23T18:06:18+00:00

    How come some of my controls are greyed out in Excel such as the 3 last Form Controls at the bottom including the drop down form control?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-03-23T17:49:46+00:00

    Let's try one more time, follow these steps.  If you get stuck, post back saying on which step you get stuck on.

    1. In a fresh workbook, we'll set up a list of entries to appear in your control...

        Go to cell A1, enter "Fred"

        In A2 enter "Bill"

        In A3 enter "Bob"

        In A4 enter "Jane"

        In A5 enter "John".

    1. Click Developer tab > Control group > Insert > ActiveX Controls > List Box (ActivX Control)
    2. Draw it on your worksheet (or just click somewhere, say cell E10).
    3. With the new control still selected, click Developer tab > Control group > Properties button.  The Properties pane opens.
    4. Look about halfway down that window, type A1:A5 next to ListFillRange. 
    5. Type D2 next to LinkedCell.
    6. You'll notice the Design Mode button on the ribbon is pressed.  Click it to un-press it and exit design mode.  The control can now be used rather than edited.
    7. Click one of the entries in your listbox.   Notice now how when you click an option in the ActiveX ListBox, D2 (the linked cell) displays the value (text), not the position of the selection. 

    Cheers

    Rich

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-03-23T17:08:27+00:00

    How do I send my Excel workbook example on this thing?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2012-03-23T17:06:52+00:00

    Cluttered meaning the ActiveX Control failed to work and the steps are not making sense in my mind and I'm frustrated. If I don't know how to develop a form in Excel I'm going to feel rather stupid.

    I just need to know enough about these controls to get the question right on the exam. The steps that you gave for ActiveX have not worked for me in Excel at all.

    The Office help does not help me in this area when I do a Bing search for controls.

    Was this answer helpful?

    0 comments