Cell value to userform

  • Hi,

    I have some code that when triggered from a userform searches using 2 combo boxes as the criteria on a different work book, choose the top ten matches perform some simple calculations the paste them into the original workbook as paste special values. works great.(some code from here).

    How do I get "them" values into the userform that is still open and eventually into the worksheet that the use for filling in in? No point me posting any code:


    A) as I have none for this bit, though have tried.

    b) I never get the layout right.


    Hope that makes sense. Any help very much appreciated.

  • Hi sorry.


    Not sure if this is allowed here is the form in the first work book and the sheet behind it fills in, The check for tool default is the trigger for the code

    The userform is called UserToolDetails you can see form and sheet marked 1 and 2. If this breached the rules or is just rubbish please remove the thread thank you