+ Reply to Thread
Results 1 to 6 of 6

how do you Link/reference a combobox

  1. #1
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Question how do you Link/reference a combobox

    Hi all,

    I have attached an .xls which will make more sense.

    I have a sheet where people input data into a worksheet. On this worksheet there is a combobox populated with a named range.

    On another sheet I wish to house a 'report' where all ansers are collated. Obviously I can use the standard '=A1' for the cells, but how do I reference info housed in a combobox?

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: how do you Link/reference a combobox

    you can use the combo box name for example

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Re: how do you Link/reference a combobox

    Thanks for that but that doesnt seem to work in the worksheet.

    I just want the cell to equal the value in the combobox.

    Hope that makes sense.

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: how do you Link/reference a combobox

    Use the combobox's proprty 'linkedCell'

    enter there: settings!C6



  5. #5
    Registered User
    Join Date
    04-23-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: how do you Link/reference a combobox

    I have almost this same issue but I have tab named 'New Material Request'. This will go to various staff and once it is complete a command button I have put on the sheet will be executed. This will execute a macro where I create a second sheet and name it 'Buyers Only' then format it and pulling only a few fields from 'New material Request' tab. I have pulled all the cell values over but now I'm stuck on how to get the value of the combo boxes and textboxes that I need. I can attached the work sheet if needed. I have only been doing VBA for about a year and this is the first time I've had to deal with combo and text boxes. I'm sure this is probably an easy process but I'm not sure if its at the field level or just getting the right text in the VBA code. Thank you for any help you can give.

  6. #6
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,162

    Re: how do you Link/reference a combobox

    simmonsv,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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