find, copy, paste

**jomili** · 07-28-2010, 01:54 PM

Okay, I'm losing it. I swear I know how to do this, but I'm just hitting blank walls.

On "Sheet1" Column A has 15 values, which populate a listbox. Column B has different values, which are related to Column A. The user makes a selection in the listbox, and the Column A value gets pasted into "Sheet1" in Cell C2. I want D2 to be the corresponding B value. I thought it would be a simple matter to select C2, look up the value in A, and copy the offset value to D2, but I'm not getting anywhere. Can anyone help?

Thanks in advance.

**Leith Ross** · 07-28-2010, 02:23 PM

Hello jomili,

Try this...

Please Login or Register  to view this content.

**jomili** · 07-28-2010, 02:36 PM

Leath,

Thanks for trying, but I don't think it even engaged; no values got pasted. There is no "Click" in the Listbox. The user selects in the listbox, then hits the "Go" button (a command button) which initiates everything.

**jomili** · 07-28-2010, 04:39 PM

D-uh, I'm so dumb. I have code that copies from the listbox to the spreadsheet. I just went back and changed that code to copy the listbox selection and the value next to it. Easy! Sorry to send you on a wild goose chase.