PDA

View Full Version : Assign value to shape by double clicking



victor222
12-01-2016, 07:57 AM
Hi everyone,

Can anyone help with vba code on assigning value to a shape in an excel sheet through double click event.
I have a number of different types of shape on the sheet, I want to be able to assign values such as time value etc. to each one by just double clicking on them.

Thanks in anticipation

mancubus
12-02-2016, 01:27 AM
hi.

searhing the vbaExpress forum and other online help communities may help you solve your problem without opening a thread.

check this out:

http://www.vbaexpress.com/forum/showthread.php?45427-Solved-Double-Click-Event-for-Shapes