ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to populate an MSForms.ReturnInteger value (https://www.excelbanter.com/excel-programming/350024-how-populate-msforms-returninteger-value.html)

Tim[_44_]

How to populate an MSForms.ReturnInteger value
 
I want to call

Private Sub txtFileID_KeyDown(ByVal KeyCode As MSForms.ReturnInteger,
ByVal Shift As Integer)

from a separate routine, something like ...

Private Sub cmdClear_Click()
Dim KeyCode As MSForms.ReturnInteger

Set KeyCode = 107 '+
KeyDown txtFileID_KeyDown KeyCode, 0
End Sub

But am having trouble assigning a value to KeyCode. I tried KeyCode =
107 and Set Keycode = 107 but the object objects. How do I do this
task?



All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com