Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combo Box List out of range error.
For I = 1 To 6
Dim Item As String Item = "I" & CStr(I) roomName = Worksheets("Sheet1").Range(Item).Value Worksheets("Sheets1").cmbList.AddItem (roomName) MsgBox (roomName) Next I dont know why this piece of code is throwsing the error. If the line Worksheets("Sheets1").cmbList.AddItem (roomName) is commented out, then the msg box shows all the 6 items there. Which tells me there is some problem with this line of code(combo box). Is there a property that needs to be set for combo box's?Please help... Thnx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
sum a range of cells that include an error | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |