Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I all, I'm programming on a Mac, (Office X) and Everything was going
great until I ran into a little problem. Mac doesn't support the RowSource property, so I must add Item. I've had sucess using a combobox in a single column application, but not in multiple. I have a sheet (codes) that contains 2 columns and (currently) 49 rows. The "A" column is the 2 didgit code and the "B" is the long description. Upon change of the combobox, we fill in a textbox with the code. I can't get the combobox to fill to columns. The code I have now: For Each cell In Worksheets("Codes").[A2:A49] ComboBox1.AddItem cell.Text Next As I said this works for single column but I need 2. Any help would be greatly appriciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox AddItem code to reference cells in a Range | Excel Discussion (Misc queries) | |||
.AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
additem to combobox with an array | Excel Discussion (Misc queries) | |||
Help with: ListBox1.AddItem (ws.Name) | Excel Worksheet Functions | |||
additem to listbox built on the fly | Excel Programming |