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

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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.


    Warmest regards

  • 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.


  • 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?


    Warmest regards

  • 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).



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


    "Varium et mutabile semper Excel"

  • I tired and make sure there isnt any spaces... but the error mesg persist

    would u mind sending me ur example?


    Warmest regards

  • 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


    Varium et mutabile semper Excel


    "Varium et mutabile semper Excel"

Participate now!

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