control arrays excel 2003

  1. F

    Creating a collection or array of CommandButtons

    Hello fellows, this is my first post so even though I read the recommendations I am sorry if I make any posting mistakes. I was assigned to optimize a very old Excel 2003 / VBA file. This is a huge file with literally thousands of controls (Labels, Textboxes, ListBoxes, CommandButtons, etc). It...
  2. S

    control arrays excel 2003

    i use excel 2003. I have written following code in 'this workbook' as it has to run when the workbook is opened. Dim ctrlarray(1 To 5) As Excel.OLEObject Dim i As Integer For i = 1 To 5 Set ctrlarray(i) = ActiveSheet.OLEObjects.Add("Commandbutton1") Next i but for some reason it gives error on...
    • sbnktn
    • Thread
    • control array control array loop control arrays excel 2003
    • Replies: 19
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top