[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]
@
wƒŠƒXƒgƒ{ƒbƒNƒX‚̘A“®xiPOSTjSHEETiƒŠƒXƒgj A B C D E 1 ‹æ•ª ‰Û ‰c Ž–¼ Ž–¼‚Q 2 A ‚ ‚© ‚ ‚ä ‚©‚ê‚¢ 3 B ‚¢ ‚« ƒCƒƒi ‚Ђç‚ß 4 C ‚¤ ‚ ‚â‚Ü‚ß ‚½‚¢ 5 D ‚¦ ‚¯ 6 E ‚¨ ‚± 7 F 8 ã‹L‚̂悤‚ÈSheet(ƒŠƒXƒg)‚ɃŠƒXƒg•\‚ª‚ ‚è‚Ü‚·B USERFORMã‚ɃŠƒXƒgƒ{ƒbƒNƒX‚ª‚R‚Â’u‚¢‚Ä‚ ‚è‚Ü‚µ‚Ä ¡AƒŠƒXƒgƒ{ƒbƒNƒX‚ð‚Q‚˜A“®‚³‚¹‚Ä‚¢‚Ü‚·B —ájListbox‚P‚Í‚`—ñ‚ªƒŠƒXƒg‚É‚È‚Á‚Ä‚¢‚Ü‚·B @@Listbox‚Q‚Í‚`—ñ‚Ì‚`‚ð‘I‚Ô‚Æ‚a—ñ‚ª•\Ž¦‚³‚ê‚Ä @@‚a`‚e‚ð‘I‚Ô‚Æ‚b—ñ‚ª•\Ž¦‚³‚ê‚é‚悤‚É‚È‚Á‚Ä‚¢‚Ü‚·B
‚»‚±‚ÅAListbox1‚Å‚`‚ð‘I‘ð‚µAListbox2‚Å‚a—ñ‚ª‘I‘ð‚³‚ê‚½ê‡‚Í Listbox3‚ð•\Ž¦‚³‚¹‚È‚¢‚ÅA
Listbox1‚ÅA‚a`‚e‚ð‘I‘ð‚µAListbox2‚Å‚b—ñ‚ª‘I‘ð‚³‚ê‚½ê‡A ‚b—ñ‚̃ŠƒXƒg‚Ìh‚©h‚ð‘I‚ñ‚¾‚çListbox3‚É‚c—ñ‚̃ŠƒXƒg‚ð h‚«h‚ð‘I‚ñ‚¾‚ç‚d—ñ‚̃ŠƒXƒg‚ð•\Ž¦‚³‚¹‚é‚ɂ͂ǂ̂悤‚ȃR[ƒh‚ð‘‚¢‚½‚ç ‚¢‚¢‚Ì‚Å‚·‚©H@‹³‚¦‚ĉº‚³‚¢B
Private Sub UserForm_Initialize() With UserForm1.ListBox1 .RowSource = "ƒŠƒXƒg!A2:A" & Range("a65536").End(xlUp).Row .ListIndex = 0 End With End Sub
Private Sub ListBox1_Change()
Dim R As Integer
With UserForm1 R = .ListBox1.ListIndex Select Case R Case 0 .ListBox2.RowSource = "ƒŠƒXƒg!b2:b" & Range("b65536").End(xlUp).Row Case 1 To 5 .ListBox2.RowSource = "ƒŠƒXƒg!C2:C" & Range("C65536").End(xlUp).Row End Select End With End Sub
ˆêˆÄ‚Å‚·‚ª¥¥¥B ƒ[ƒNƒV[ƒg‘¤‚Ŕ͈͖¼‚ð‚‚¯‚Ä‚¨‚B D—ñ‚̃ŠƒXƒg‚ðu‚©v E—ñ‚̃ŠƒXƒg‚ðu‚«vEEEE Me.Listbox3.RowSource = "ƒŠƒXƒg!" & Me.Listbox2.Text ‚Æ‚©Bi‚Ý‚â‚Ù‚è‚ñj
i‚Ý‚â‚Ù‚è‚ñj—l‰ñ“š‚ ‚肪‚Æ‚¤‚²‚´‚¢‚Ü‚·B ŽQl‚É‚µ‚ÄŽ©•ª‚È‚è‚É‚à‚¤‚µl‚¦‚Ă݂悤‚Æ‚¨‚à‚¢‚Ü‚·B ‚ ‚肪‚Æ‚¤‚²‚´‚¢‚Ü‚µ‚½B
[ ˆê——(ÅVXV‡) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.