fill combobox with values from a row of another worksheet

[lui de sagun]

Hi,

Need your help on this please. In my "view" sheet, I have a dropdown (cmbTickets). I want to fill-in the dropdown (cmbTickets) with values from "Tickets" column in "ServiceDesk" sheet. Also, beside the dropdown, I want to see the amount that corresponds to the value from "Discounted Cost" column (can be seen in the ServiceDesk column) that I will choose from the dropdown. of If you can help me work-out a sample micro vb for this please. I attached my file for you to see what I am talking about.

 

[kchiba]

Hi, the attached picture will show you what needs to be done.

You have to switch to Design Mode in the Developer's tab, and the fo to the properties of the ComboBox and enter the Range in the ListFillRange box.

 

[lui de sagun]

Thanks very much! Really appreciated it!