Pass activecell value from worksheet to userform

What I am trying to do, is that when the user is on a cell that contains a part number and then presses a hot key to open up the user form, I would like the userform to recognise the value from the worksheet and drop it into a textbox on the userform and then pull up its extended details from another worksheet. As it currently stands the userform opens up upon pressing a button on the worksheet and works fine in this fashion but the user has to type the number in which should not need to be necessary. The sheet that has the part number where the process will be initiated is sheet2 while sheet10 is where it is pulling up extended details for the part number in question.

Please Login or Register  to view this content.