- ©«¤l
- 66
- ¥DÃD
- 16
- ºëµØ
- 0
- ¿n¤À
- 99
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-8-12
- ³Ì«áµn¿ý
- 2023-10-26
|
µJÂI¤Î±±¨îÅv°ÝÃD
¥»©«³Ì«á¥Ñ reangame ©ó 2023-4-19 23:21 ½s¿è
- Private Sub CommandButton1_Click()
- ActiveCell.Value = "¡¶"
- ActiveCell.Offset(0, 1).Select
- ThisWorkbook.ActiveSheet.Activate ' ±N±±¨îÅvÂಾ¨ì¥Ø«e¤u§@ªí
- End Sub
½Æ»s¥N½X ½Ð°Ý§Ú¦b¤u§@ªí¤¤«Ø¥ß¤@Ó«ö¶s1¡A©I¥sªí³æ¡A
µM«áªí³æ¤W«Ø¥ß«ö¶s2(¤W¤è¬°µ{¦¡½X)¡A
¦b¤u§@ªí·í«eÀx¦s®æ´¡¤J¤å¦r«á¡A¿ï¨ú¥kÃäÀx¦s®æ¡A°õ¦æ³£¥¿½T¡A
¦ý¬O¡Aµ²§ô¤§«á¡AµLªkª½±µ¨Ï¥ÎÁä½L¦b¤u§@ªí¿é¤J¸ê®Æ¡A
ÂIÀ»¤è¦VÁä¡Aµo²{ªí³æ¤Wªº«ö¶s¦b¤Á´«¿ï¨úª¬ºA¡A
¸Ó¦p¦ó¼¶¼gµ{¦¡½X¡AÂIÀ»«ö¶s2§¹¦¨°Ê§@¤§«á¡A¥i¥Hª½±µ¨Ï¥ÎÁä½L¦b¤u§@ªí¿é¤J¸ê®Æ©O?- Private Sub UserForm_Activate()
- Dim ctrl As Control
- For Each ctrl In Me.Controls
- If TypeName(ctrl) = "CommandButton" Then
- ctrl.TabStop = False
- End If
- Next ctrl
- End Sub
½Æ»s¥N½X TabStopÄÝ©Ê+DefaultÄݩʧ¡¤w³]©w¬°false- Private Sub CommandButton1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
- If KeyCode = vbKeyTab Then
- Application.SendKeys "{TAB}"
- KeyCode = 0
- End If
- End Sub
½Æ»s¥N½X ³o¬Ochatgptµ¹ªº¸Ñªk¡A¤´µMµLªk¸Ñ¨M- Sub showUF1()
- UserForm1.Show modeless
- End Sub
½Æ»s¥N½X ³o¬O«ö¶s1ªºµ{¦¡½X |
|