right click option on a text box

[slmi1313]

Hello All,

I have created a textbox using the control toolbox on a sheet, is there any way to get the right click options when using the mouse,(like copy,paste...)

Thanks

[Leith Ross]

Hello slmi1313,

There is no easy way to do this. Here is short explanation of what is going on. Excel has a special window class it uses as its "Drawing Layer". This includes controls (Forms and ActiveX), charts, and Auto Shapes. ActiveX or OLE objects create windows of their own on this "Drawing Layer" window. Each window has a code procedure that handles the mouse and keyboard inputs. You would have to create a new object based on the ActiveX control and modify this window procedure to respond to a Right Click event. The code at this point would have to create a context menu to provide the functional features you want.