Adding items to a right click menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kezza - 21 May 2006 02:22 GMT

Hello all, is it possible to add "insert time" and "insert date" to the
right click popup menu? I am trying to get away from keyboard
shortcuts.
TIA
Kezza

Reply to this Message

Norman Jones - 21 May 2006 05:23 GMT

Hi Kezza,

> Hello all, is it possible to add "insert time" and "insert date" to the
> right click popup menu? I am trying to get away from keyboard
> shortcuts.

Ron de Bruin has sample code for adding (or removing) commands to the
right-click menu at:

http://www.rondebruin.com/menuid.htm#Add

See particularly Ron's Add_Controls procedure on that page.

In your case, the macros to be added to the menu might be:

'=============>>
Public Sub InsertDate()
Selection.Value = Date
End Sub

'----------------->

Public Sub InsertTime()
Selection.Value = Time
End Sub
'<<=============

---
Regards,
Norman

Reply to this Message

Kezza - 21 May 2006 06:15 GMT

Thanks heaps for your help.
Kind Regards
Kezza

Reply to this Message

Stefano Gatto - 21 May 2006 09:53 GMT

Maybe this helps: Ctrl-: and Ctrl-; are keyboard shortcuts inserting time and
date resp in Excel.

Signature

Stefano Gatto

> Thanks heaps for your help.
> Kind Regards
> Kezza

Reply to this Message