+ Reply to Thread
Results 1 to 4 of 4

Add ComboBox to Specific Column when adding a new row

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Add ComboBox to Specific Column when adding a new row

    So I had this terrific little macro going in my sheet. Whatever someone inserted a new row, it would automatically add a checkbox and a form dropdown to specific columns in that new row, along with linked cells for both:
    Please Login or Register  to view this content.
    Unfortunately, due to [reasons], I have to start my workbook over using ActiveX dropdowns instead of form control dropdowns. I have changed the relevant line of code to this:
    Please Login or Register  to view this content.
    Now, instead of inserting the combobox in column G of the new row, it inserts the combobox in whatever cell happens to be active. It does pull the appropriate range of dropdown values and it does set the linkedcell to be the right one, but I really need the dropdown itself to go into column G. Why is it not doing that, and how can I fix it?

  2. #2
    Registered User
    Join Date
    02-11-2014
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add ComboBox to Specific Column when adding a new row

    It occurs to me that I can sort of solve this by adding
    Please Login or Register  to view this content.
    to select column G first, but I'm wondering if there's a better or more appropriate way (and I'd still like to know if there's a reason that
    Please Login or Register  to view this content.
    isn't enough to tell it to put the dropdown in column G, when it works just fine for the checkbox in the other column).

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Add ComboBox to Specific Column when adding a new row

    Maybe try something like this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    02-11-2014
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Add ComboBox to Specific Column when adding a new row

    That appears to have done the trick! I guess it wasn't working because I was leaving out info that it was expecting. Thank you very much for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding a column with variables for specific entries
    By AndyPandy in forum Excel General
    Replies: 4
    Last Post: 02-05-2013, 04:43 AM
  2. Replies: 4
    Last Post: 07-24-2012, 11:58 AM
  3. Adding Column B, when Column A has specific data
    By foto4cash in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2011, 01:36 PM
  4. adding values to a combobox from a specific range of cells
    By blindzero678 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-05-2010, 07:02 PM
  5. Adding specific cells in column
    By MG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2006, 06:15 PM

Tags for this Thread

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