Passing a string from worksheet module to userform.

Hi all!

This is a simplified version of what I'm trying to achieve, I've lost track of how many failed attempts I've had at what must be something incredibly simple.

In a worksheet module, to initialise the userform.

Please Login or Register  to view this content.

Userform code,

Please Login or Register  to view this content.

The (simplified) intention is to search for the item selected in the combobox on the worksheet and copy the selection value (myString) into the next column.
Please note that this needs to be done with a string variable for it to work with the less simple version, not copy / paste, range object, etc.

Thanks in advance for any suggestions.

That was the incredibly simple something that I was missing!

Thanks, Mike!