Double click on cell > Open User form > insert value

Hi, currently I have this code with double click and insert value, but i want to improve this...

Current code and result:

Please Login or Register  to view this content.

r1.png

I want to improve with after double click open userform to insert value in 1 cell

Volume (V):
Number(N):
Today date

r3.png

r2.png

Thank you in advance..

You could change your code in:

Please Login or Register  to view this content.

And then use and userform with two textboxes named txt_vol for volume and txt_num for the number and one commandButton named cmd_ok and use this code:

Please Login or Register  to view this content.

Regards,
Antonio

You could change your code in:

Please Login or Register  to view this content.

And then use and userform with two textboxes named txt_vol for volume and txt_num for the number and one commandButton named cmd_ok and use this code:

Please Login or Register  to view this content.

Regards,
Antonio

WOW! Thank you Antonio.. Many thanks for sample too...