+ Reply to Thread
Results 1 to 5 of 5

VBA Code to have a repeating form control /Active X control (List box) in every row

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    VBA Code to have a repeating form control /Active X control (List box) in every row

    Hi

    I am new to this forum and really dont know much about excel programming.

    I have a spreadsheet (attached). I have inserted an active x - combo box. What I need is for the combo box to be repeated in each cell in that column going down i.e. everytime the user completes the combo box, a new combo box to be created in the cell beneath it in that column.

    I am trying to avoid having to individually create combo boxes and linking each box to the respective cell where the entered value should be collated.

    Any help will be sincerely appreciated.

    Regards
    Last edited by Ehezve; 08-28-2013 at 08:53 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA Code to have a repeating form control /Active X control (List box) in every row

    How about using Data>Validation... with the List option?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: VBA Code to have a repeating form control /Active X control (List box) in every row

    Thanks Norie

    How do I do that?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA Code to have a repeating form control /Active X control (List box) in every row

    Select all the cells you want the dropdown in.

    Goto the Data tab and click Data>Validation...

    In the dialog select List from the Allow dropdown, in the Source section enter =$BJ$2:$BJ$26 or click the button on the right to select the range from the worksheet.

    Click OK and you're done.

  5. #5
    Registered User
    Join Date
    08-28-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: VBA Code to have a repeating form control /Active X control (List box) in every row

    Thank you so much Norie. Its much easier and less complicated.

+ 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. Enable/Disable Form controls on a worksheet (not Active X Control)
    By vaniravi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2012, 07:42 AM
  2. Copy Active X control and code
    By BRISBANEBOB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 12:11 AM
  3. Code a data validation list in a spreadsheet control from a form
    By robx2309 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2011, 05:01 PM
  4. Active x, excel sheet form control
    By erikgutten in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-19-2010, 09:19 AM
  5. Option button (active control) code to perform a calculation
    By Taggsuk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2008, 07:00 PM

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