Hi, Chip Pearson

thanks for your precious tips. I can now use that VB form instead o
installing VB software.

Need your help..

I've created the VB code in excel but it seems did not worked ou
property, what could be the reason? The code is follows:

Private Sub cmdExit_Click()
End
End Sub

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

lblInfo.Caption = "A key was pressed. Keycode= " + Str(KeyCode) +
Shift= " + Str(Shift)

End Sub


Cheers.

Chip Pearson wrote:
*You can create a UserForm in the VBA Editor (ALT+F11). In VBA, go
to the Insert menu and choose UserForm. You'll find that creating
a userform in VBA is very similar to creating a form in VB.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"tanks1308 " wrote in
message ...
Hi all, I need to create a form and is using Excel to do it,
can it be
done? The form I can use using VB s/w to do it but my office
did not
have VB so i have to use Excel for this purpose.
Appreciate your help. Thanks.


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com