LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Adding the same content to multiple combo boxes

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf New Users to Excel 1 March 27th 09 06:29 PM
multiple combo boxes jeff Excel Discussion (Misc queries) 2 December 16th 08 05:02 PM
Multiple combo boxes with unique duplicates showing only Nemo New Users to Excel 0 July 6th 07 03:20 PM
Problem Adding new Combo Boxes [email protected] Excel Discussion (Misc queries) 2 September 12th 06 09:58 AM
multiple combo boxes LilyDog7 Excel Discussion (Misc queries) 4 October 17th 05 10:22 PM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"