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/

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/

Hi Chip Pearson, thanks for your precious tip. I can now work with V
form without having to install VB s/w. Thanks so much.


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

Hi, Chip Pearson

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

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

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

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/