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: 112
Default Using arrays to create Combobox items

Hello out there!
I want to use the same items several times in different comboboxes, i.e.
a currency selection (EUR, USD, SEK, DKK......). There are 7 instances where
the user selects the currency to use (and it can be different currency at
every selection). Instead of reading the list from a sheet or writing the
same ComboboX.AddItem= "EUR" and so on for every new combobox, I wanted to
use an array and a for...next loop that can be used for every combobox
creation. But, arrays are not allowed in for...next statements.
Can it be done in another neat way?
Best regards
Mats
 
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
Grouping Items by Arrays In need of enlightenment Excel Discussion (Misc queries) 3 March 18th 07 05:30 PM
Put items in combobox using VBA and toolbox JoeS01[_2_] Excel Programming 3 June 28th 05 09:33 AM
how to add items to combobox Marek Excel Programming 3 August 30th 04 10:31 AM
ComboBox Items Todd Huttenstine[_2_] Excel Programming 1 December 14th 03 11:12 PM
ComboBox items Keith Willshaw Excel Programming 2 July 17th 03 11:22 AM


All times are GMT +1. The time now is 10:25 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"