Userform Find Cell From ComboBox Value And Write To Adjacent Cell

[pferder]

I am having a problem using data from my combobox to find the cell on the worksheet and write to an adjacent cell.

Worksheet name is "A ENTREGAR C001-999"
ComboBox that provides the search value is "cmbCliente"
ComboBox that has the data to enter in another cell is "cmbCuerpos"
CommandButton name's "cmdModificar"

I would like to be able to take the text from "cmbCliente", find this text in Col A of worksheet "A ENTREGAR C001-999" and write the Value of "cmbCuerpos" in the Col C. when "cmdModificar" is pressed.

Thanks in advance!

[foundy]

Hi,

Try This:

Please Login or Register  to view this content.

[pferder]

Thank you foundy, but itīs not working. I'll try to be more specific.

I would like to be able to take the text from "cmbCliente" (ComboBox), find this text in Col A of worksheet "A ENTREGAR C001-999" and write the Value of "cmbCuerpos" (and another variables as "cmbMadera", "cmbColchon", "cmbMesa", etc) in the Col C (and D, E, F, G, etc.) when "cmdModificar" is pressed.

A little hint, the Col A, where I search for values, is formed by a formula.

Thanks!

[foundy]

Hi pferder,

Are there duplicate values in column A ?

[pferder]

No Mr. Foundy, they are all unique.

[Norie]

How have you populated cmbCliente?

If it's from a contiguous range with unique values then you can use the combobox's ListIndex to find the row the selected value is on.

Alternatively you could use something like this.

Please Login or Register  to view this content.

[jaslake]

Another...

Please Login or Register  to view this content.

[pferder]

Norie! it worked perfectly, thank you a lot! How can a I populate the ComboBoxes from a column in the same sheet?

[Norie]

Aren't you already doing that?

If you aren't you could use something like this, where A2 is the row the data starts in.

Please Login or Register  to view this content.

[pferder]

Thanks Norie and foundy!!!!!! It's working perfectly