VBA Code that references another cell in the same row as a command button

[Motox]

Hi Forum,

I have a worksheet called “Parts” that has information for each unique part, including the unique “Part Numbers” down column A.

On another sheet, “Part Details”, I can enter a part number into cell A5 and details for that part are displayed (using VLookups).

What I would like is to have a button, in column E, for each row in the Parts sheet. When the button is selected the Part Number associated with that row would appear in cell A5 of the Part Details sheet.

What VBA code would I need for the button? I have tried recording a macro of copying and pasting the Part Numbers into cell A5 to see what that code looks like but I have been unable to modify that code to do what I want.

Thanks very much

Dave

[Greg M]

Hi there,

See if the following code does what you need. It might appear "wordy" but I've deliberately implemented it in a few separate steps so that you can see what's involved.

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M



P. S.

Please Login or Register  to view this content.

will certainly work, but it's a little less easy on the eye, and also on the grey cells when you're reading it six months from now!