ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤À­¶B°õ¦æ¤À­¶Aµ{¦¡

[µo°Ý] ¤À­¶B°õ¦æ¤À­¶Aµ{¦¡

·Q¼g¤@­Óµ{¦¡
§Q¥Î²Ä¤G­¶µ{¦¡ command button
¨Ó°õ¦æ²Ä¤@­¶µ{¦¡commandbutton

¦ý³£·|¥X²{ run time error "28" out of stack space
·Q½Ð±Ð¦U¦ì¥ý¶i¬O­n«ç»ò­×§ï?




°ÝÃD.png
2022-5-7 10:52

test.zip (21.7 KB)
²öÅý¥L¤H¿ù»~¶Ë®`¦Û¤v

¦^´_ 1# y54161212
  1. Private Sub CommandButton1_Click()  '<--** Sheet2 ªºµ{§Ç**
  2. Dim sht As Worksheet, sht2 As Worksheet
  3. Dim i As Integer, j As Integer, k As Integer
  4. Set sht = Worksheets("Sheet1")
  5. Set sht2 = Worksheets("Sheet2")
  6. Application.Goto sht.Range("A1")
  7. '  CommandButton1_Click    <--  °õ¦æªº¬OSheet2 ªºµ{§Ç
  8. '**   CommandButton1_Click  ³o¬OSheet2 ªºµ{§Ç
  9. '** ¤@ª½¦b ¤@ª½¦a¦A ­«½Æ°õ¦æSheet2 ªºCommandButton1_Click µ{§Ç
  10. '** ¿ù»~½X 28 ªí°ïÅ|ªÅ¶¡¤£°÷¥Î¤F *****
  11.   'Private Sub   ªí¨p¥Îªºµ{§Ç­n¥Î   Run  ¨Ó©I¥s °õ¦æªºµ{§Ç
  12.   Run "Sheet1.CommandButton1_Click" '**°õ¦æSheet1 ªºµ{§Ç**
  13. End Sub
½Æ»s¥N½X

TOP

¦^´_  y54161212
lee88 µoªí©ó 2022-5-7 15:09


·PÁ±zªº§Y®É¦^À³
³o¤]¬O§Ú¤@ª½¥H¨Óªº°ÝÃD

¦]¬°¹³¨ä¥Lªº§Ú¤]¬O·Ó¤W­zªº¼gªk
«o¤S¥i¥H°õ¦æ~


   
001.png
2022-5-7 16:04

002.png
2022-5-7 16:05
²öÅý¥L¤H¿ù»~¶Ë®`¦Û¤v

TOP

·PÁ±zªº§Y®É¦^À³
³o¤]¬O§Ú¤@ª½¥H¨Óªº°ÝÃD

¦]¬°¹³¨ä¥Lªº§Ú¤]¬O·Ó¤W­zªº¼gªk
«o¤S¥i¥H°õ¦æ~


  ...
y54161212 µoªí©ó 2022-5-7 16:06



­è­èµy·L´ú¸Õ¤F¤@¤U
Run "Sheet1.commandbutton1_click"
³o¤@­Ó«ü¥O
§Y¨Ï§Ú§âsheet1ªº¦WºÙ§ï¬° LSR
Åܦ¨ "Run "sheet1.commandbutton1_click" ÁÙ¬O¥i¥H°õ¦æ

·N«ä¬O¥u­n¶}©l´N½T»{¤F¶Ü? ©ÎªÌ§Ú¥i¥H¦b­þ¬d¨ì«ü¤Þ?
²öÅý¥L¤H¿ù»~¶Ë®`¦Û¤v

TOP

¥»©«³Ì«á¥Ñ lee88 ©ó 2022-5-8 14:16 ½s¿è

¦^´_ 4# y54161212
§Y¨Ï§Ú§âsheet1ªº¦WºÙ§ï¬° LSR
Åܦ¨ "Run "sheet1.commandbutton1_click" ÁÙ¬O¥i¥H°õ¦æ

¦WºÙ§ï¬° LSR À³¬O§ï¤u§@ªíªº¦WºÙ
§A¤£¬O§ï¤u§@ªíª«¥óªº¦WºÙ,©Ò¥HÁÙ¬O¥i¥H°õ¦æ

¥¼©R¦W.png
2022-5-8 14:16



Public Sub CommandButton5_Click()= Sub CommandButton5_Click()
Public  ¤½¥Îªºµ{§Ç ·íµM¥i¥H©I¥s
**********************************************
¦pªG  ¤½¥Îªºµ{§Ç ¦b¤@¯ë¼Ò²Õ¤¤
¥i¥H¤£¥[¤W ¤@¯ë¼Ò²Õªº¦WºÙ ª½±µ ©I¥s ¤½¥Îªºµ{§Ç

TOP

¦^´_ 5# lee88


    ¸g¹L±zªº´£¿ô
    ¥J²Ó¤@¬Ý¡A¥i¥H©I¥sªº½T¹ê¼g¦¨public !
    §Ú¦A¦n¦n¬ã¨s¬Ý¬Ý ¤u§@¼Ò²Õ ¸ò sheet¦WºÙªº®t²§
    ¸U¤À·PÁÂ!!!
²öÅý¥L¤H¿ù»~¶Ë®`¦Û¤v

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD