Is the VB in Excel a mini-version of the real thing? Some of the codings I tried cannot work at all in Excel-VB.
2007-06-13 23:53:24 · 4 answers · asked by Terence 1 in Computers & Internet ➔ Software
VBA is a subset of VB which runs inside one of the office applications. As a result VBA inherits the current Office object library and application instance by default and any references that are included. However in VB you have to create the application instances if you need to manipulate one or more of the Office application objects.
2007-06-13 23:58:01 · answer #1 · answered by Del Piero 10 7 · 0⤊ 0⤋
Excel uses VB script.
learn more at:
2007-06-13 23:58:06 · answer #2 · answered by ELfaGeek 7 · 0⤊ 0⤋
Yah, it's the same thing. You just need to know special functions and procedurs for doing operations with excel cells.
2007-06-13 23:58:12 · answer #3 · answered by Anonymous · 0⤊ 0⤋
a million. "IF" command consistently starts with "IF" and finishes with "end IF" 2. a guy or woman form should be up thus far to tutor the modification inclusive of "hi" and a eco-friendly bar (be conscious the code Me is used to ward off repeating the call of somebody form. on your case Me = UserForm1 Herewith is what your code could be private sub cmdlogin_click() IF txtusername.fee="texas1" AND txtpassword.fee="Kitty" Then With Me.Label1 .Caption = "hi" .BackColor = &HFF00& end With Else With Me.Label1 .Caption = "so long" .BackColor = &HFF& end With end If Me.Repaint 'replace userform1 end Sub
2016-10-09 04:32:01 · answer #4 · answered by Anonymous · 0⤊ 0⤋