Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    162

    Re: Breaking split at not 0

    Sorry guys, slacked off on creating a proper question, thank you for your input though.

    Since i needed jumps to happen at specific times i ended up with something like this:


    Sub Sequence()...
  2. Replies
    8
    Views
    162

    Breaking split at not 0

    Hello guys,

    I have a sequence:

    <colgroup><col></colgroup><tbody>
    00000001



    00000005
  3. Replies
    2
    Views
    63

    Variables between modules

    Hello guys,

    I've been having trouble getting global variables to work.

    Module1 code:

    Option Explicit Public Test As Variant
    Sub init()
    test = 2
    Call testing
  4. Replies
    6
    Views
    230

    Minimizing utility

    Hello guys,
    https://imgur.com/a/cKDQI3K
    I have a file at work that has interesting functionality. It has a minimize set up for each month that you can expand to see per day. It's very convenient...
  5. Replies
    3
    Views
    85

    Re: Parameter changing once function run

    Ah, i see now, thank you!
  6. Replies
    3
    Views
    85

    Parameter changing once function run

    Hey guys, i am making a small function to add up all the numbers between 2 numbers.

    My code:


    Sub Sums() Dim a As Long, b As Long, i As Long, n As Long, ta As Long, tb As Long, ak As Long,...
  7. Replies
    9
    Views
    1,433

    Re: User forms and keeping array variables

    Thank you for your input, but the let statement leaves my data empty in any way i try to write it.
    Since this is a setter, do i need an initial getter to pick the data up?


    I tried to avoid...
  8. Replies
    9
    Views
    1,433

    Re: User forms and keeping array variables

    I moved it out because i was not able to to pick up allData() once i reach the event:ChoiceComboBox_Change()

    I'm not sure how public variables work but i dim them before all the subs:

    Public...
  9. Replies
    9
    Views
    1,433

    Re: User forms and keeping array variables

    Module 1:

    Sub DisplayFormEditLoc(allData() As Variant, weightData() As Variant)
    Dim myInitFrm As DisplayFormEditLocs
    Dim strCaption As String, i As Long, posSize As Long, posWeight As...
  10. Replies
    9
    Views
    1,433

    Re: User forms and keeping array variables

    Well apperently i redimed my array inside a sub. Now it's actaully global and is reachable by class:

    Call ChoiceComboBoxChange(indexer)


    Sub ChoiceComboBoxChange(indexer)...
  11. Replies
    9
    Views
    1,433

    User forms and keeping array variables

    Hello,

    I am making a user form and I'd like it to contain: a drop down list, and 4 labels + 4 text boxes.

    The idea is after a choice is made in drop down list, 4 label values are changed...
  12. Replies
    3
    Views
    74

    Re: Saving a variable into clipboard

    That makes a lot of sense and is easier to control, thanks for the idea!
  13. Replies
    3
    Views
    74

    Saving a variable into clipboard

    Hello guys,

    i have a file that i only want to be editable by user forms. For that result i protect the sheet and unprotect it only when running the macro.

    But users are still able to browse...
  14. Replies
    6
    Views
    149

    Re: Recursive factorial

    Hello Joe4,

    thank you for your answer, but the whole point of this is to make a recursive function and figure out how they work :)}

    Just noticed my initial statement:
    I'm trying to learn how...
  15. Replies
    6
    Views
    149

    Recursive factorial

    Hey guys,

    I'm trying to learn how to use factorials, this is a simple example:


    Option Explicit
    Function factorials(nr As Long, Optional factorialsTest As Long = 1)
    Dim test As Variant...
  16. Replies
    1
    Views
    97

    Re: Using a variable inside code

    The solution was to use a function:


    If fullArray(i, 2) >= 1 And fullArray(i, 2) < 3 Then sheet2() = fillUpArray(sheet2())
    If fullArray(i, 2) >= 3 And fullArray(i, 2) < 6 Then sheet3() =...
  17. Replies
    1
    Views
    97

    Using a variable inside code

    Hello guys,

    I'm trying to minimize lines that i have in my code and i ran into a small problem I'm not sure how to approach

    I have 3 arrays that i fill up depending on a variable:


    If...
  18. Replies
    3
    Views
    78

    Re: Keeping array values after macro run

    First time i tried declaring outside of scope, of course that's the issue, thanks again Fluff!! :)
  19. Replies
    3
    Views
    78

    Keeping array values after macro run

    Hey guys,

    I have a project that I'm making and it contains 3 arrays. Once i run the macro, all the actions are done, but the array is not erased, if i re-run the macro the values inside keep...
  20. Replies
    3
    Views
    124

    Re: Help with a change in Macro

    Hey, can you add an additional column?

    Then set something up like:


    lastRow = Cells.Find(what:="*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row
    With Range("Z1:Z"&lastRow)
    ...
  21. Replies
    3
    Views
    124

    Re: Help with a change in Macro

    Hey, should be possible, but i need to see your code to tell you more
  22. Replies
    36
    Views
    848

    Re: Check if a cell contains same digits

    Hi, something like this?


    Option Explicit


    Option Explicit


    Sub Worksheet_Change(ByVal Target As Range)
  23. Replies
    10
    Views
    222

    Re: Exiting a nested for cycle

    Hey Eric, thats exactly what i have! But I'm afraid when expanding i will run into problems
  24. Replies
    10
    Views
    222

    Re: Exiting a nested for cycle

    Sorry not sure what you mean by that, but let's imagine i'm browsing through a 2d array that has random numbers inside and i want to exit as soon as even a single copy of the number i'm looking for...
  25. Replies
    10
    Views
    222

    Re: Exiting a nested for cycle

    This will require an overhaul of my code, but it should work, i will attempt to implement it!
Results 1 to 25 of 75
Page 1 of 3 1 2 3