Retrieving data from a cell to combo box

[bhangra]

I a have list of data that changes whenever the values are retrieved from the database. I am trying to figure out how to retrieve the values from the cells from one worksheet and add it to the combo box in another sheet.

Thanks

[vikas.bhandari]

Hi there!

If you are using a Active x control Combobox, then you can simply assign a Named Range to the data you are looking to pull and then Assign that particular name to Combobox's ListFillRange property. It will make the combobox dynamic. As soon as your values are changed, the values in Combobox will be updated.

Thanks,
Vikas B

[bhangra]

Hi Vikas,

Can you please give me an example to how this might be done. I have never done this before.

Thanks

[vikas.bhandari]

Please find attached an example of Combobox linked to a data in different worksheet

Attachment 170914

Thanks,
Vikas B

[bulkmar2011]

I also need to update one combobox in SHeet one from cell B2 but whenever I use LinkRange to my NamedRng I cannot use RANDBETWEEN function because my data are NAMES and not numbers? Got any other Function in NamedRng that I can use please?

[Pavan.Upadhyay]

I want link data of selected combi box cell. how can i do this please help.

[Cutter]

Hello Pavan.Upadhyay, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.