三个文本框textbox1、textbox2、textbox3,一个按钮commandbutton1。我需要达到的效果是:当光标在textbox1上时,就在textbox1中输入内容;textbox2和textbox3也是这样用。我写的代码是这样的:
Private Sub CommandButton1_Click()
If TextBox1.SetFocus Then
TextBox1 = 1
ElseIf TextBox2.SetFocus Then
TextBox2 = 1
End If
End Sub
这里我只用了两个文本框来试验,就已经报错了,第3个就更不用试了。运行并单击按钮之后提示“缺少函数或变量”。不知这个问题该如何解决?向高手求教!多谢啦!
楼主ï¼æ个æ¦å¿µä½ è¦ææ¸ æ¥ï¼è¿ä¸ªå æ ä¼ååçï¼æ¯å¦å½å æ ä½äºtextbox1æ¶åï¼ä½ ç¹å»æé®çæ¶åï¼è¿ä¸ªæ¶åç¦ç¹è¿ é转移å°æé®ä¸ï¼æ以ï¼ä½ åå»å¤æå æ æ¯ä¸æ¯å¨textbox1ä¸å°±å¤±å»æä¹äºï¼å 为å®è¯å®ä¸å¨é£éï¼é£ä¹æ没æåæ³å¯ä»¥è§£å³è¿ä¸ªé®é¢äºï¼åæ³å½ç¶æ¯æçï¼å°±æ¯è®¾ç½®ä¸ä¸ªå ¬å ±åéç¨æ¥è®°å½è·å¾ç¦ç¹çtextboxï¼è¿æ ·å°±ä¼è½»èæ举ç解å³é®é¢
Public my_object As ObjectPrivate Sub CommandButton1_Click()
my_object.Value = 1
End Sub
Private Sub TextBox1_GotFocus()
Set my_object = Me.TextBox1
End Sub
Private Sub TextBox2_GotFocus()
Set my_object = Me.TextBox2
End Sub
Private Sub TextBox3_GotFocus()
Set my_object = Me.TextBox3
End Sub
代ç 解æï¼
设置ä¸ä¸ªå
Œ
±åémy_objectï¼ç¶åwordå½ä¸æä¸ä¸ªtextboxï¼å称åå«ä¸ºtextbox1,textbox2,textbox3ï¼ç¶ååå«æ·»å äºä»¶ä»£ç TextBox1_GotFocus
ï¼å½å
æ ä½äºtextboxå
å³è·å¾ç¦ç¹ï¼ä¼èªå¨è§¦åäºä»¶ï¼ï¼ç¶åætextboxèµå¼ç»å
Œ
±åéï¼ç¹å»æé®åï¼ç»å
Œ
±åémy_objectèµå¼å³å¯
é¦å
谢谢æ¨çåçãä½æ¯ææ°å»ºä¸ä¸ªçªä½ã3个ææ¬æ¡ã1个æé®ï¼å称åé®é¢ä¸çä¸æ ·ï¼ç¶åææ¨ç代ç ç²è¿å»ãè¿è¡ãç¹æé®ï¼ç»åºçé误æ示æ¯ï¼âè¿è¡æ¶é误â91âã对象åéæWithååéæªè®¾ç½®ãâ
请é®è¿ä¸ªè¦æä¹å¤çï¼æ¯æç²è´´ä»£ç çé®é¢åï¼
wordçªä½ä¸é¢çTextBox没æGotFocusäºä»¶ï¼åªæä¸ä¸ªExitäºä»¶å¯ä»¥ç¨ï¼å¦æä½ æ¯å¨word页é¢å½ä¸æå ¥çTextboxæ§ä»¶å¯ä»¥ä½¿ç¨ä¸è¿°ä»£ç ï¼å¦ææ¯çªä½ä¸æå ¥çtextboxå¾æ´æ¢äºä»¶ä»£ç ï¼å ·ä½ä»£ç å¦ä¸ï¼äº²æµéè¿
Public my_object As ObjectPrivate Sub CommandButton1_Click()
my_object.Value = 1
End Sub
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Set my_object = Me.TextBox1
End Sub
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Set my_object = Me.TextBox2
End Sub
Private Sub TextBox3_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Set my_object = Me.TextBox3
End Sub