Can Excel use as a VB form creation?

T

tanks1308

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.
 
C

Chip Pearson

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
 
T

tanks1308

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.
 
T

tanks1308

Hi, Chip Pearson

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

Cheers.
 
T

tanks1308

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.
 
C

Chip Pearson

Your code works for me. Specifically what problems are you
having?


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