right mouse click - cut copy paste in userform textboxes?
 

Is there a way to enable the right mouse click in userforms to allow cut copy
paste in text/combo boxes?

The default setting seems to have this option disabled??
Thanks,
Roger

right mouse click - cut copy paste in userform textboxes?
 

There arre a number of menus in Excel such as the worksheet Find that
the right mouse doesn't work but the shortcuts (Copy Cntl-C, Paste
Cntl-V and cut Cntl-X) do work. Not sure why.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=166990

Microsoft Office Help

right mouse click - cut copy paste in userform textboxes?
 

I asked this forum and others if that could be done and no one seemed to know
if its possible. In the mean time I have been using

Ctrl + C to Copy
Ctrl + V to Paste

I guess you could possibly right some code in the Right Click Event that
would intialize a custom menu, but the trick would be how to access the
clipboard.

Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan


"Roger on Excel" wrote:

Is there a way to enable the right mouse click in userforms to allow cut copy
paste in text/combo boxes?

The default setting seems to have this option disabled??
Thanks,
Roger

right mouse click - cut copy paste in userform textboxes?
 

I have asked this question before in this forum and other forums, but with no
reply that I'm aware of. I have been using

Ctrl + C to Copy
Ctrl + V to Paste

There may be a way to put code into the Right Click Event that would
intialize a custom menu, but the trick would be accessing the clipboard. Not
sure if that is possible.
--
Cheers,
Ryan


"Roger on Excel" wrote:

Is there a way to enable the right mouse click in userforms to allow cut copy
paste in text/combo boxes?

The default setting seems to have this option disabled??
Thanks,
Roger

right mouse click - cut copy paste in userform textboxes?
 

If you get off the ground with a rightclick menu the following clipboard
routines may be useful

Public Function TestClip() As Boolean

' Test for empty clipboard
Application.Volatile (True)

TestClip = IIf(Len(Trim(GetOffClipboard)) = 0, False, True)

End Function

Public Sub PutOnClipboard(Text As String)

Dim DataObj As New MSForms.DataObject ' REFERENCE SET IF INCLUDE DUMMY
USERFORM MODULE !
DataObj.SetText Text

DataObj.PutInClipboard
End Sub

Public Function GetOffClipboard() As String

' Extract text from clipboard
Application.Volatile (True)

Dim DataObj As New MSForms.DataObject
DataObj.GetFromClipboard

On Error GoTo ClipBError
GetOffClipboard = DataObj.GetText

Exit Function

ClipBError:
GetOffClipboard = ""

End Function

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"Ryan H" wrote:

I have asked this question before in this forum and other forums, but with no
reply that I'm aware of. I have been using

Ctrl + C to Copy
Ctrl + V to Paste

There may be a way to put code into the Right Click Event that would
intialize a custom menu, but the trick would be accessing the clipboard. Not
sure if that is possible.
--
Cheers,
Ryan


"Roger on Excel" wrote:

Is there a way to enable the right mouse click in userforms to allow cut copy
paste in text/combo boxes?

The default setting seems to have this option disabled??
Thanks,
Roger

right mouse click - cut copy paste in userform textboxes?
 

Hi,

You may find this useful.
http://www.andypope.info/vba/uf_contextualmenu.htm

The principles can be applied to a combobox.

Cheers
Andy

Roger on Excel wrote:
Is there a way to enable the right mouse click in userforms to allow cut copy
paste in text/combo boxes?

The default setting seems to have this option disabled??
Thanks,
Roger

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info