+ Reply to Thread
Results 1 to 6 of 6

Embed combo box in cell

  1. #1
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    262

    Embed combo box in cell

    Thanks to several on this site, my project is almost complete. If I could ask for anything more it would be for the 5 combo boxes to be enbedded in the cells they are covering ( or at least navigate like cells, on enter or arrow keys. See attached workbook. If it means that the boxes can't function as they do now, I'm not sure it's worth it though.
    Thank you,
    Sick
    Attached Files Attached Files
    Last edited by sick stigma; 01-16-2011 at 05:37 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,281

    Re: Embed combo box in cell

    Where are the combo boxes?

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,012

    Re: Embed combo box in cell

    What sheets and what cells are you asking to have combo boxes on? Have you tried Data Validataion Lists?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    262

    Re: Embed combo box in cell

    Sorry!
    Sheet=Granite
    Boxes are in P53:P57.
    They were originally data validation, list boxes but the font was too small. Plus I really enjoy the match feature of the combo list boxes.
    Sick

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,012

    Re: Embed combo box in cell

    Hi Sick Stigma,

    I find a site that explains a lot of this on http://www.exceltip.com/st/Add_Combo...Excel/300.html
    After adding a ComboDropdown on the Form Control Dialog on a Tab named Control there is a place for
    Input Range (which is like your validation list) and Cell Link - which is where the data goes after clicking on the value.

    What problems are you having exactly, trying to get a ComboBox attached to a cell?

    I hope that helps.

  6. #6
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Mexico
    Posts
    200

    Re: Embed combo box in cell


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1