Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Combo Boxes in VBA

Comment:

Hi I was wondering if anyone knows how to collect data from excel, and code it in VBA so it transfers it into a combo box in VBA, because i'm doing a project and i need the names of 4 teams that are on a worksheet in excel and i need them in a combo box in VBA, by using a for next loop, preferably. Thanks

Name: egkenny
Date: January 2, 2004 at 19:38:48 Pacific

Reply:

Given: Worksheet named: Sheet1 Combo box named: MyComboBox Data on worksheet: B4: Fox B5: Bear B6: Swan B7: Cat B8: Dog Copy data to combo box: Worksheets("Sheet1").Activate For i = 4 To 8 rng = "B" + Format(i) MyComboBox.AddItem Range(rng).Value Next i

0

Reply:

Thanks for the help

0

Html code to maximize web...

Web page not in search en...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: If it was the other way around, you could report a bug to Mozilla, and since Netscape is based on Mozilla, eventually it would get fixed. If you try reporting the IE behavior to Microsoft as a bug, yo...

Summary: G'day , i am trying to workout how to change the contence of a combo box in referance to what was in the previous box IE if someone selects dell from 1 combo box the next box will have the model of de...

Summary: ok Reno has help me figure out/show me that i can use VBS input and VBS yes no box. does VBS have combo boxes? i googled it but didnt get much. is it possible to add a combobox in batch? Thank you ...