sub procedure

  1. N

    Changing a Sub Procedure Name After the Fact

    Hello, I just renamed a sub procedure in a VB macro from "Sub DropDowns()" to "Sub ProbeSelect()". The macro is written to control a series of Form Control Combo Boxes (hence the name DropDowns) that were embedded in the worksheet (not on a Userform) but I changed a few of the Combo Boxes to...
    • nryan
    • Thread
    • cannot run the macro macro name change macro not available name change sub procedure
    • Replies: 7
    • Forum: Excel Questions
  2. M

    Argument in a Sub Procedure

    Hello there, I searched through the questions and didn't find any question regarding arguments in sub procedures. I am trying to write a code that will require a number for a variable (i), but if no number is typed in, it will use its default value. Sub Ende(Optional Teste As Long =...
  3. C

    Exit a Sub

    Hey, I have written a procedure in VB that goes through a column and sorts it. The content and size of this column changes daily when the report is run. The problem arises when there is nothing in this column. When there is nothing in the column I get 'Error code 9'. Is there anyway of adding...
  4. G

    Write a sub procedure for a timetable

    I need help with this one, I am new to VBA and cannot figure out how to do this. I am using Excel 2007. What I need to do is take data from this table and have it generate a timetable. <table border="0" cellpadding="0" cellspacing="0" width="507"><col style="width: 107pt;" width="142">...

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