Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Oct 16, 2:40 pm, "Peter T" <peter_t@discussions wrote:
small typo - PS, for your listboxes named Level01 et use "Level" & right$("0" & i, 2) ' or maybe ("0" & i - 1, 2) ' or maybe ("0" & i + 1, 2) if say maintaining a zero baseindexmethod with first name starting at '01 as in the demo Peter T Thanks everyone.... These are very useful for me.. I especially liked these as I think these are easy for me to understand... GetCtrlObj(UserForm1, "Level0" & i).additem("Text") Me.Controls("Level" & Format(X, "00")).AddItem Items(X-1) Thanks again.. I will comeback once I try this.... Regards Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Control array | Excel Programming | |||
Help with Control Array Sum Formula | Excel Discussion (Misc queries) | |||
Control Array Help... | Excel Programming | |||
Creating a Control Array | Excel Programming | |||
Dump 2D array into Control | Excel Programming |