Adding the same content to multiple combo boxes
From: keaven (kfreeman_at_nas.edi)
Date: 06/10/04
- Next message: David McRitchie: "Re: Behaviour of Save as and Displayalerts"
- Previous message: Don Guillett: "Re: last row"
- Next in thread: Chip Pearson: "Re: Adding the same content to multiple combo boxes"
- Reply: Chip Pearson: "Re: Adding the same content to multiple combo boxes"
- Reply: Tom Ogilvy: "Re: Adding the same content to multiple combo boxes"
- Reply: anonymous_at_discussions.microsoft.com: "Adding the same content to multiple combo boxes"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 11:35:27 -0700
Okay.. here's the deal, i have a user form in excel that
gathers information. In one section there is a series of
six combo boxes. What i have been trying to do is have
code in the UserForm_Initialize() sub that adds items to
the combo boxes. All six combo boxes need the same
information added to them.
what i would like to do is something like:
for each X in (1,2,3,4,5,6)
with Me.ComboBoxX
.AddItem "a"
.AddItem "b"
end with
next
trying to get it to go through all 6 boxes.. but this is
not working and i cant figure out how to get it to work
without reapeating the .AddItem list for each and every
box. is there a faster way to do it?
-keaven
- Next message: David McRitchie: "Re: Behaviour of Save as and Displayalerts"
- Previous message: Don Guillett: "Re: last row"
- Next in thread: Chip Pearson: "Re: Adding the same content to multiple combo boxes"
- Reply: Chip Pearson: "Re: Adding the same content to multiple combo boxes"
- Reply: Tom Ogilvy: "Re: Adding the same content to multiple combo boxes"
- Reply: anonymous_at_discussions.microsoft.com: "Adding the same content to multiple combo boxes"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
