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

[µo°Ý] Userform³Ì¤j¤Æ(¥B¤º®e¤ñ¨Ò¦Û°Ê©ñ¤j?)

¦^´_ 27# bobomi


    ¤j¤j±z¦n,«e¤@½gªº°ÝÃD§Ú³£§ä¨ìµª®×¤F,¦bSaveSetting ThisWorkbook.Name, "SSS"=>¥þ³¡ªºUSERFORM³£«ü¦V¦P¤@­Ó¦WºÙ§Y¥in­Óªí³æ³£¬Û¦P¤j¤p
¥t¥~ÁÙ¦³¤@­Ó°ÝÃD(©êºp,°ÝÃD«Ü¦h...)

´N¬OÁY¤p«ö¶s·|¥X²{¿ù»~,¤£¯àÁY¤p
§Ú¥Ø«e§@ªk¬O±NÁY¤p«ö¶s¨S±oÂI,¦³¿ìªkÅý¥L¤£·|¥X²{¿ù»~,µM«áÁY¤p¨ì¤u§@¦C,µ¥¨ì­n¥Îªº®É­Ô¦AÂI¤@¤U¤u§@¦CªºÀÉ®×´N·|¦Û°Ê¸õ¥X­ì¥»¤j¤pªºªí³æ¶Ü?
  1. ocx.Left = ocx_xy(0) * Rw
  2. ocx.Top = ocx_xy(1) * Rh
  3. ocx.Width = ocx_xy(2) * Rw
  4. ocx.Height = ocx_xy(3) * Rh
½Æ»s¥N½X
¿ù»~µo¥Í¦b¤W¤èªºheight¨ºÃä
PKKO

TOP

¥»©«³Ì«á¥Ñ bobomi ©ó 2015-5-23 19:51 ½s¿è

(1) ¤å¦r­ì¥»Åã¥Ü¥|­Ó¦r,¥u¦³¥X²{¤T­Ó¦r,²{¦b¤]¥i¦Û¦æ¾a©Ô¼e¤@ÂI´NÅã¥Ü¥X¨Ó¥¿½T¤ñ¨Ò,©Ò¥H¥|­Ó¦r³£¥i¥HÅã¥Ü
     ->  §Ú¹w³]´N¬O¤å¦r¥u¦³©Ô°ª¤~ÁY©ñ, ©Ô¼e«h¤£ÁY©ñ,  ²{¦b¤w¸g§ï¦¨©Ô¼e¤]·|ÁY©ñ
(2) ­×¥¿­ì§@¤u§@¦C¬Ý¤£¨ì¹Ï¥Ü

1.zip (48.15 KB)

TOP

¦^´_ 32# bobomi


    ¤j¤j,·sª©ªº¨Ï¥Î¤W©Ç©Çªº

¦b¤Á´«¤£¦Pªí³æªº®É­Ô
¤U¤èµ{¦¡½Xªº¦a¤è·|µLªk°õ¦æ
  1. Private Sub UserForm_Activate()
  2.   modForm.UserForm_SetButton Me
  3. End Sub
½Æ»s¥N½X
PKKO

TOP

1.zip (50.81 KB)

¥Ø«eµo²{¦³¤@­Ó°ÝÃD
¨Ò¦p:
¥Î·Æ¹«¨åÀ»  UserForm  ¨Ï¨ä³Ì¤j¤Æ«á
·Æ¹«²¾¨ì¤u¨ã¦C¥hÂIÀ»¨º­Ó EXCEL ¹Ï¥Ü
EXCEL ¾ã¦U·|¶×ÁY¤p¨ì¤u¨ã¦C (³o³¡¤À¬O¥¿±`ªº )
¦A¦¸ÂIÀ»¨º­Ó EXCEL ¹Ï¥Ü , EXCEL ´N·|ÁÙ­ìÅܤj (³o³¡¤À¤]¬O¥¿±`ªº )
°ÝÃD¨Ó¤F
·í EXCEL ÁÙ­ìÅܤj®É
EXCEL ·|¦h¨Æªº§â  ³B©ó ³Ì¤j¤Æªº UserForm  ¦Û°Ê½Õ¦^¤@·h¤j¤p

³o­Ó¼È®É¸Ñ¨M¤£¤F

TOP

¦^´_ 34# bobomi
½Ð°Ý¥Ø«e§Úªºuserform¥Î§Aªºµ{¦¡¥i¥HÅý¨Ï¥ÎªÌ¦Û¥ÑÁY©ñ¡A¦ý¬O­n«ç¼Ë¤~¯àÅý image ª«¥ó¤]¯à¸òµÛÁY©ñ???

¸Ô²Ó¤º®e¦b³o¸Ì

TOP

ÁÂÁ¤j¤j­Ìªº±Ð¾É¡A¸Ñ¨M¤F¨ì2021¦~¨Ï¥Îwin10 ÁY©ñ¤ñ¨Ò§âªí®æº¡¨ì¿Ã¹õ¥~­±ªº°ÝÃD¡AÁÂÁ³á!!

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD