wigi
Well-known Member
- Joined
- Jul 10, 2006
- Messages
- 7,964
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hi all
Here's the problem I'm facing.
I have a class module that handles the BeforeDropOrPaste event of a bunch of Labels on a userform. All is going well.
In the userform module, I have another event, a Listbox_MouseMove event. Users can move elements of a listbox into any one of the labels on the userform.
But I need to track whether shift or ctrl was pressed when moving. How should I pass on that information in a public variable? I've defined a public variable in the userform module:
Public lShift As Long
But for some reason I can't use it in the class module. If I write to a sheet and read back from it, it works perfectly.
I hope someone can help with it.
Thanks in advance,
Wigi
Here's the problem I'm facing.
I have a class module that handles the BeforeDropOrPaste event of a bunch of Labels on a userform. All is going well.
In the userform module, I have another event, a Listbox_MouseMove event. Users can move elements of a listbox into any one of the labels on the userform.
But I need to track whether shift or ctrl was pressed when moving. How should I pass on that information in a public variable? I've defined a public variable in the userform module:
Public lShift As Long
But for some reason I can't use it in the class module. If I write to a sheet and read back from it, it works perfectly.
I hope someone can help with it.
Thanks in advance,
Wigi