How to link combobox values to cell values...

[Tunk Ayauit]

Hi all.

I'm putting together a userform. In a combo box I have several concepts. In a worksheet I have the desired values, what would the code be to link the selected concept to the value?

Thanks in advance.

Tunk

[mojo249]

Hi Tunk

Search for "setting combobox rowsource". There are numerous methods depending on your circumstances.

The easiest way is to go to the VB editor, and select the combobox. In the properties window (bottom left), scroll down to Rowsource and enter the sheet name and range eg =Sheet1!A1:A10