+ Reply to Thread
Results 1 to 2 of 2

ActiveX ComboBox :: How to setup range & cell link

  1. #1
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    ActiveX ComboBox :: How to setup range & cell link

    See workbook attachment:
    Combobox.xlsm

    I like ActiveX combobox, because I can make the font size bigger, and many other things. BUT I have no clue how to get it all setup. Keep in mind I'm a laymen for programming. I did, however, setup a workbook with the combobox and a worksheet where all the data goes! (see attachment)

    RANGE:
    I need the Range to be a list of names : Sheets("Accounts").Range("F6:F11")

    CELL LINK:
    I need to Cell Link to be :
    - EITHER: Sheets("Accounts").Range("G2") (in number format like it is with regular comboboxes)
    - OR: Sheets("Accounts").Range("F2") (in name format, whatever name is selected)


    Please help!
    Last edited by nenadmail; 08-16-2012 at 05:55 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: ActiveX ComboBox :: How to setup range & cell link

    Create a named range for the list of names and use that NAME in the combobox listfill range value
    Attached Files Attached Files
    Ben Van Johnson

+ 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