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

combobox²K¥[°}¦C

combobox²K¥[°}¦C

¦U¦ì¤j¤j:
·Q½Ð°Ý§Q¥Î¥H¤U
xlVal10 = UserForm5.ComboBox2
With Worksheets("¤u§@ªí1")
Set F = .Columns(10).Find(xlVal10, Lookat:=xlWhole)
End With
§ä¥X¨ÓªºF¬O­Ó¤@ºûªº°}¦C
½Ð°Ý­n«ç»ò§â³o­ÓF.offset(0,2)ªº°}¦Cªº²K¥[¨ìcombobox1¤º??

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD