Your code works for me. Specifically what problems are you
having?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"tanks1308 " wrote in
message ...
Hi, Chip Pearson
thanks for your precious tips. I can now use that VB form
instead of
installing VB software.
Need your help..
I've created the VB code in excel but it seems did not worked
out
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/