Search:

Type: Posts; User: mitchbvi; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. I have tried the watch suggestion and I may not...

    I have tried the watch suggestion and I may not be doing it correctly , two watches first just the array name ArrTemp() and second a new line I added to check if the assignment to a cell was the...
  2. Thanks for taking the time. I do not get an...

    Thanks for taking the time.


    I do not get an error when running the Module at that point or any other, the ArrTemp() simply goes blank. Also as I pointed out in my post running a test with a...
  3. Thanks again, for taking the time. The array is...

    Thanks again, for taking the time. The array is Public and is in the same module as the code I posted. Just in case I have made an error this is the start of the module

    Option Explicit

    Option...
  4. Losing values in publicly declared array in middle of sub

    I have a Series of Macros that Calculate a Normal Distribution and overlay the result on a histogram of the original Data Set. It works fine in Test but when I apply it to a real world issue it...
  5. Hi Zeddy The Array is already defined as...

    Hi Zeddy

    The Array is already defined as Public, I think it is something to do with the syntax. I tried to set the array to the two arrays that are the feed for the frequency function but that did...
  6. How to pass the result of a Frequency Function to an array

    This has me stumped I have written series of Macros to run a limited Monte Carlo simulation and produce charts that overlay a Normal Distribution of the data. I am now trying to clean it up (speed...
  7. Replies
    15
    Views
    2,457

    RG I think I have messed it up again I tried...

    RG

    I think I have messed it up again I tried to reply using the email address you provided and was asked to authentic and that failed as well do you have my files yet?

    Sorry

    peter
  8. Replies
    15
    Views
    2,457

    Hi Maud Thanks for the input tried that and it...

    Hi Maud

    Thanks for the input tried that and it does not cycle twice as it did on exit but it still goes to the command button "Next Stock" bypassing the next text box Opt 6 which is what I would...
  9. Replies
    15
    Views
    2,457

    RG Tried Application.enablevents= False/True...

    RG

    Tried Application.enablevents= False/True same result

    thanks

    Peter
  10. Replies
    15
    Views
    2,457

    Hi RG Do not have a problem passing the file...

    Hi RG

    Do not have a problem passing the file onto you. However I would like to do it directly as there are lots of bits of code from other people and I am not sure I have made that clear through...
  11. Replies
    15
    Views
    2,457

    RG Thank you Still no luck I changed your code...

    RG Thank you

    Still no luck I changed your code to conform with my UserForm hopefully I did that correctly see below.



    It still cycle twice now does not give me an error but moves to the...
  12. Replies
    15
    Views
    2,457

    Thanks for that suggestion, there is not a yes...

    Thanks for that suggestion, there is not a yes option unless I should include an else option in the if then but if the test is passed I want to move on. Deleting the cancel = true for some reason...
  13. Replies
    15
    Views
    2,457

    Conditionally change focus on user form

    I have a user From with 6 input boxes. One of those receives a strike price. If that price is lower than a the purchase price I want to tell the operator and then depending on the response move the...
  14. The start is a form that allows me to select a...

    The start is a form that allows me to select a number of reports of which this sequence is one.

    The Sub "ExpReport1Year" is called first that builds the two tables then it opens the report.

    In...
  15. Thank you both for taking the time to reply. ...

    Thank you both for taking the time to reply.

    Mark, I will try and explain. The Batch # referred to in my earlier post groups records that may include both revenue and expenses. What I wanted to...
  16. Can you use an SQL statement as part of another in Having or Where conditions

    I have data base that at present I use a Docmd Run Sql to create a table based on a field not being Null and grouped by a batch number. I use that table in another Docmd RunSQL to filter all the...
  17. Thanks Mark , I am dense I know as I am still...

    Thanks Mark , I am dense I know as I am still missing something but at least problem for now is solved and I will work on your suggestion.
  18. Hi Mark first my apologies for not replying to...

    Hi Mark

    first my apologies for not replying to your post but my internet has been down for two days.

    Secondly I discovered that I need Max rather than Min, I had started out asking for Min...
  19. I had posted a reply and went to edit it and seem...

    I had posted a reply and went to edit it and seem to loose the lot. First thank for taking the time to respond to my post unfortunately I feel I did not outline properly what the problem is.

    The...
  20. I also need to sort by month as well and in fact...

    I also need to sort by month as well and in fact I needed Dmax rather than Dmin. Many thanks for the simple suggestion Occam's Razor got me this time. Using the month in the second query does not...
  21. Use Dmin (or other aggregate functions) on subset of records within query

    In a query each record includes "BatchID" , "Month", "year". There are a number of records for each BatchID, what I want to do is add a field to each record showing the min year in that batch. I have...
  22. Add Vertical Line to an Excel chart with VBA

    First I am using Excel 2011 for Mac and all I can find on the Web seems to refer to windows versions of Excel.
    I have a cumulative frequency chart (line ) and I would like to add a vertical line/bar...
  23. Replies
    7
    Views
    1,585

    Hi Andrew I have started a new thread as I...

    Hi Andrew

    I have started a new thread as I have run into a problem sorting my results and I thought that was the correct thing to do, and wanted to let you know in case you have any ideas. I have...
  24. Replies
    2
    Views
    1,144

    Sorting two-dimensional array

    I am using a User Form to select outputs for various cells. Then the worksheet is recalculated X times and that data stored in an array. I have had a lot of help getting this far but while I can sort...
  25. Replies
    7
    Views
    1,585

    Think I may Have it

    First My thanks for staying with me on this , it has been of great help. I was having trouble as you would have guessed and I had also posted a request on another Forum. The suggestion from that was...
Results 1 to 25 of 194
Page 1 of 8 1 2 3 4