sub1

  1. T

    Excel VBA executed instruction not in sequence

    I created a simple count down to delay the display of my math result. The strange thing happen was, one of my math input (Sub1) not get to display before the count down. Can anyone help me with what's wrong in the code below? ' Function: Making Number from 3 to 10, with count downSub...
  2. L

    global variable and future sub

    Hi I want to define a variable as a global so I can use it on all other sub()s in the module. It is working fine but I noticed one thing. If I created a new sub, lets say sub4(), then this sub4() will not be able to get the value of x unless I go to sub1() and run it again. Why is that? I...
  3. P

    week2date function different result on two machines

    Hi Guys, I'm using the below function which turns a week number into a week Public Function Week2Date(WeekNo As Long) As Date Dim Jan1 As Date Dim Sub1 As Boolean Dim Ret As Date Jan1 = DateSerial(Year(Date), 1, 1) 'Sub1 =...

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