Search:

Type: Posts; User: 8700Rakf; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Thread: VBA Graph

    by 8700Rakf
    Replies
    1
    Views
    145

    VBA Graph

    Hey Guys

    How do I add a Graph by using VBA, and add the data on my own, also through vba?

    thanks in advance! :)
  2. Replies
    6
    Views
    148

    Re: separate something in a cell.

    Thank you, that explains it! :)
  3. Replies
    6
    Views
    148

    Re: separate something in a cell.

    Then you would have to handle it like an array?
  4. Replies
    6
    Views
    148

    separate something in a cell.

    So i have a cell with which as the following in it - 100 > m > 10000 - In my case its in cell A21

    Is it possible to write a code that seperates the 100 and 1000 to another variable?
  5. Replies
    13
    Views
    496

    Re: Not running as hoped

    So if i add i button, that activates Version dropdown, when pushed on it. everything works fine, and becomes as intended, its just not dynamically changing as i want, when changing something in the...
  6. Replies
    13
    Views
    496

    Re: Not running as hoped

    Bump :)
  7. Replies
    13
    Views
    496

    Re: Not running as hoped

    Typer is a sort of scaling, where it multiplies the existing predefined limits with 1(Normal), 5(Post Scale) and 20(Scale). This was the only way i could figure out, a way for it to scale every...
  8. Replies
    13
    Views
    496

    Re: Not running as hoped

    Maybe, I am not sure. What kind of problems does merge cells cause?

    Actually, everything was running smootly until I added the LoadValues_NIST sub, after that thing didnt work out, correctly. So...
  9. Replies
    13
    Views
    496

    Re: Not running as hoped

    you sure it returns 0?

    I see, sorry for the trouble, but thanks for having a look at it though! And yeah there is quiet a lot to look at, so it a bit complicated.
  10. Replies
    13
    Views
    496

    Re: Not running as hoped

    Yes I am using the Debugger. So when I am running it without it, the area which is supposed to change, just keeps showing 0.
    When using debugger, inside the code, it does what it is supposed to do.
  11. Replies
    13
    Views
    496

    Re: Not running as hoped

    Bump
  12. Replies
    13
    Views
    496

    Re: Not running as hoped

    https://www.dropbox.com/s/is4gbia1g9z9iud/NytScale.xlsm?dl=0

    Thats is the link

    What I am trying to do is, that i want it to change dynamically, depending on the choices you make. Not sure if...
  13. Replies
    13
    Views
    496

    Not running as hoped

    Hello

    I have some code that is on paper( I think ), should run fine. When i use debug, I can see that all is going well and as expected.

    But when i do it outside the debugger, and on my sheet,...
  14. Replies
    2
    Views
    225

    Re: Dynamic Change of Table

    Nothing??? :S
  15. Replies
    2
    Views
    225

    Re: Dynamic Change of Table

    Bump :)
  16. Replies
    2
    Views
    225

    Dynamic Change of Table

    So i have several dropdown menues, where VersionBox, ClassBox etc already is predefined by my code.

    So what i am having trouble with, is to have a dynamic way to change the range values. it all...
  17. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    It worked, thank you!!!
  18. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    So how would you implement this activate event ?
  19. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    I havent managed to make it work, and its very frustrating.

    thank you so much for your time.
  20. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    This is what i've done, but the code dont work as it did before anymore.


    Private Sub Workbook_Open()

    '----------------Initialising-----------------------------------


    Dim Versions As...
  21. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    And what about the sub parts?

    as fare as i know, subs dont work inside subs?
  22. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    When i do that, All the Me keywords dont work, and i am not sure How to change that
  23. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    Bump :)
  24. Replies
    15
    Views
    550

    Re: Sheet1 Not running

    Private Sub ClassBox_Change()



    Select Case VersionBox




    Case "OIML R51 1996 (Old EU)"
  25. Replies
    15
    Views
    550

    Sheet1 Not running

    So I have a lot of ComboBox on my sheet1, I cant seem to activate it execpt if I go to sheet2, and then back to Sheet1. Then they function as intended.

    Is it possible to avoid this process, for...
Results 1 to 25 of 32
Page 1 of 2 1 2