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

奬ª÷­n¦p¦ó¥Îvba­pºâ©O

¦^´_ 40# sillykin


    ¤j¤j¤£¦n·N«ä¡A½Ð°Ý¤p°ÝÃD
Àç·~³æ¦ì³d¥ôÃB¤£¤@©w¬°500¡A¦³¤Ö¼Æ¤H­û·|§ó°Ê
¯à§_¤£¥h§PÂ_³d¥ôÃB
ÁÙ¦³Àç·~³æ¦ì¤W­­¬°150¡A000
ºÞ²z³æ¦ì¤W­­¬°120¡A000
¸ê°T³æ¦ì¤W­­¬°100¡A000
¯à§_¸Ñ¨M©O¡AÁÂÁÂ

TOP

¦^´_ 41# sillykin
Àç·~³æ¦ì³d¥ôÃB¤£¤@©w¬°500¡A¦³¤Ö¼Æ¤H­û·|§ó°Ê ¤Ö¼Æ¤H¬O­þ¨Ç¤H,­n¦³¦W³æ¥i°Ñ¦Ò

µ{¦¡½X­n¤F¸Ñ¤@¤U,³o¼Ë¬O¤£·|¶i¨Bªº
  1. '¼úª÷¤W­­ = IIf(³¡ªù = "Àç·~³æ¦ì", 15000, 12000)
  2.         ¼úª÷¤W­­ = IIf(³¡ªù = "Àç·~³æ¦ì", 15000, IIf(³¡ªù = "ºÞ²z³æ¦ì", 12000, 10000))
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 42# GBKEE


    ÁÂÁ¤j«ü±Ð¡A§Ú·|§V¤O¾Ç²ß
³d¥ôÃB¯à§_±qÁ`ªí¥h§ì³d¥ôÃB¡AÁ`ªí³d¥ôÃB¥Ñ¤H¤u¦Û¦æ¿é¤J

TOP

¦^´_ 43# sillykin


    ¼úª÷¤W­­ = IIf(³¡ªù = "Àç·~³æ¦ì", 150000, IIf(³¡ªù = "ºÞ²z³æ¦ì", 120000, 100000))
§Ú§â奬ª÷¤W­­§ó§ï¬°150,000 ; 120,000 ; 100,000
¬°¦ó·|²£¥Í·¸¦ì±¡§Î????

¥¼©R¦W.JPG (11.63 KB)

¥¼©R¦W.JPG

TOP

¦^´_  sillykin


    ¼úª÷¤W­­ = IIf(³¡ªù = "Àç·~³æ¦ì", 150000, IIf(³¡ªù = "ºÞ²z³æ¦ì", 120000, 10 ...
sillykin µoªí©ó 2013-7-30 21:25


¦³·¸¦ì¬O¥¿±`ªº°Ú.

½Ð°Ñ¬Ý ExcelVBA »¡©ú¤¤ªº "¸ê®Æ«¬ºAºK­n"
¸Ì­±¦³»¡¨ì :

Integer ¦û2 ­Ó¦ì¤¸²Õ, ¥iªí¥Ü¼Æ¦r½d³ò±q -32,768 ¨ì 32,767
¦Ó Long(long integer)  «h¦û 4 ­Ó¦ì¤¸²Õ, ¥iªí¥Ü¼Æ¦r½d³ò±q -2,147,483,648 ¨ì 2,147,483,647

©Ò¥H§A¥u­n§âµ{¦¡¤¤ Dim «á­±¦³ As Integer  ªº§ï¦¨ As Long  À³¸Ó´N¥i¥H¤F

TOP

¦^´_ 44# sillykin
¹ï¤£°_ ²´ªá¤F, 42©«; ª÷ÃB¼Æ¦r¤Ö¤F1­Ó0 ¼úª÷¤W­­ As Integer ­n§ï¦¨¦pluhpro»¡ ¼úª÷¤W­­ As Long
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 38# GBKEE


    ÁÂÁ¤j¤jªº¦^ÂÐ..·PÁÂ

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD