Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple "With" commands - Please help
HELP
I have a screen full of comboboxes and when I initiate the form I want to populate the drop downs. I want to populate many of them with the same info but cannot work out the WITH commands to populate many boxes with the same info. i.e. With cboxDay1,cboxDay2 .add ("1") .add ("2") End With - This command does not work Please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple "With" commands - Please help
You could loop through all the comboboxes and set each individually, or you
could just set one and "copy" to the others. I put 6 comboboxes (cboxday1 through cboxday6) on a worksheet: Dim iCtr As Long With Worksheets("sheet1") With .OLEObjects("cboxday1").Object .Clear .AddItem 1 .AddItem 2 .AddItem 3 End With For iCtr = 2 To 6 .OLEObjects("cboxday" & iCtr).Object.List _ = .OLEObjects("cboxday1").Object.List Next iCtr End With Azza wrote: HELP I have a screen full of comboboxes and when I initiate the form I want to populate the drop downs. I want to populate many of them with the same info but cannot work out the WITH commands to populate many boxes with the same info. i.e. With cboxDay1,cboxDay2 .add ("1") .add ("2") End With - This command does not work Please help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
how can I still use the "/" lotus commands with Excel 2003 SP2 | Excel Discussion (Misc queries) | |||
Formulas to speed up many manual "=()" commands | Excel Worksheet Functions | |||
"end" + "down" commands not working | Excel Discussion (Misc queries) |