sub procedures

  1. T

    Using 'If Then' when a procedure is called

    Hi, I'm using a large excel model that uses a datadump function to move data from inputs into a data dump sheet. I've added a tracker to the model to track changes made to it and now the data dump function is really, really slow. Is there a way to use If and Then with sub procedures so I...
  2. B

    Userform Controls VBA

    Hi All, Need your help I have 48 Labels on a userform with the name Day1,Day2,Day 3 Ect. Ect. Day47 and Day48 I want to avoid having 48 Sub Procedures example below Private Sub Day1_Click() Userform1.Hide '>>>Call Function and Call Sub Will Go Here<<< End Sub Is there a way to have a...
  3. D

    Error handling with nested subroutines

    I have a Sub procedure that calls, in sequence, 5 other sub procedures:- Sub Analyse On Error GoTo ErrHandler: Call Sub_A Call Sub_B (output from Sub_A) Call Sub_C (output from Sub_B) Call Sub_D (output from Sub_C) Call Sub_E (output from Sub_D) ErrHandler: End If Err.Number <> 0...
  4. AT--o

    Sub that takes the value of a function

    Hi. In excel 2007. My function takes its arguments from cells on the same row that it is inserted. I just copy it down. The problem is I need to change the Interior of this cell (the one containing the function) according to values that while taken from operations between the arguments are not...
  5. Maverick99

    To Call a Sub from a Case Statement

    I have run across some code that uses Case Statements, based upon a user's Button Selection from a UserForm. This is located in the UserForm Event Module. I thought this would be straight forward to have it call a Sub "WriteToLog," if the Case Statement is true. However, it's not working for...

Watch MrExcel Video

This Week's Hot Topics

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
Top