VBA: Need to link selected data from List Box to another wor

  • Hi all


    i created a list box whith data in my user form.


    The user would select one of the item, and the select item would appear in Worksheet("data"); cell E1.


    How do i create that link?
    Bear in mind, i went to properties to check, there isnt any function for this.


    rdgs

  • James,


    If this is in relation to preious post then the Row Source Property of the list boxx would be Date and the Control Source Proerty of the list box will be sheet1!a1 to place whichever value the users chooses in A1 on sheet 1.



    Regards
    Weasel

  • Hi Pesky,


    i tried inputing Projection!E1 at Control Source property at the user form... but it returns this error message:
    Could not set Control Source property.Invalid property value.



    How? how?


    Rdgs
    james

  • Hi James,


    I tried to reproduce your Error' but it works fine for me..
    Have you got any extra quote marks or spaces in your ControlSource or RowSource property names? The only way I could get the Error was if I put "Projection!E1" (complete with quotes).


    HTH


    Chris


    I haven't failed, I've found 10,000 ways that don't work. (Benjamin Franklin)

    Cheers,
    Chris


    "Varium et mutabile semper Excel"

  • Try the attached.


    The items for the ListBox are on the sheet "data". Click the button on "data" to show the form, then select an item from the list. Click OK to dismiss the form, then have a look at "Projection" - the value you chose is in E1 :yes:


    Hope this helps


    Chris


    Varium et mutabile semper Excel

    Cheers,
    Chris


    "Varium et mutabile semper Excel"

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!