Hi all,

Sorry for two post in one day but I'm on a roll so thought I should ask while I am still motivated

Not 100% sure its possible, but I would like to copy and paste a value from a text box onto a running list in a sheet called "Quote" when I double click the row, the list starts at B16.

The macro I used to use is below, its also asks for a quantity and adds it to the next cell (C16), but this was kindly donated by a member here and was not designed to do what I now ask of it, somehow it did run once on double click but I could not find any output and now it hangs on Set Btn = ActiveSheet.Buttons(Application.Caller)

Any advice appreciated.

Please Login or Register  to view this content.