Userform Find Cell from ComboBox Value and write to adjacent cell

[msommerf]

Hi,

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

Worksheet name is Fleet
ComboBox Name is ComboBox7
TextBox name is TextBox3
CommandButton1

I would like to be able to take the text from ComboBox7, find this text in Col A of worksheet Fleet and write the Value of TextBox3 in the adjacent cell in Col B. when
the CommandButton1 is pressed.

Can anyone help please?

[StephenR]

Try this:

Please Login or Register  to view this content.

[msommerf]

Many, Many thanks. This worked first Time. I have been struggling with this for hours.

Thank you.