Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Re: Adding a vertical line in conditional formatting data bars at 100%

    There is a way to do this. I am experimenting with some code. Your (manual) line has a name and can be handled as a shape in VBA. So you can check the highest value in the range (here 215) and then...
  2. Re: Injecting a VAR (variance) calculation in a Sumproduct formula

    If the output of the VAR function is (or can be) an array, then in theory it can be done.
  3. Re: Selection Change Macro Error when Autofilter Hides Row

    What you could do is set the graph range to a range in a hidden sheet. Call the range, say, NIINGraphInp.
    Then in your selectionChange sub when a cell is selected copy the values of...
  4. Replies
    1
    Views
    81

    Re: Problem with getfolder

    Is there a way in which you can shorten the file names (and path)? You can check the length of the intended path + filename to see if it is longer than 256 characters using the function Len(). If so,...
  5. Replies
    1
    Views
    100

    Re: Paste from clipboard, VBA

    See if this can help you
    https://www.mrexcel.com/forum/excel-questions/852600-vba-replace-picture-clipboard-copy.html
  6. Replies
    1
    Views
    105

    Re: Excel Ghost Behaviour

    No idea why it is doing that. But I am wondering, why don't you use normal validation dropdown in that column?

    I also think, if you want to persist with a combobox, that you should create the...
  7. Re: Range of cells on one sheet, sorted, blanks removed and data put into a column on another.

    Dethanb,
    another request.
    Next time that you post code, please use code brackets around your code to get it nicely formatted. See below in blue and red how to do it (or use the 'code' button to...
  8. Re: Range of cells on one sheet, sorted, blanks removed and data put into a column on another.

    This should do the trick


    Option Explicit


    Sub SetupStaffRoster()
    Dim wsSR As Worksheet, wsOV As Worksheet
    Dim vIn As Variant, vOut As Variant
    Dim lRi As Long, lRo As Long, lCi...
  9. Thread: vba form

    by sijpie
    Replies
    11
    Views
    443

    Re: vba form

    In that case you need to use the first version of the code.

    And to do the pivot for such a table depends on what you want to get out. I can only think of a work-around: if your workerstable...
  10. Thread: vba form

    by sijpie
    Replies
    11
    Views
    443

    Re: vba form

    I have arranged the two tables as follows. This allows you in Table1 to sort on position or name, etc. It also allows you to do an easy pivottable.

    https://i.ibb.co/hXbPvjP/names1.jpg

    The...
  11. Replies
    3
    Views
    199

    Re: How to modify UDF into VBA Macro

    Ah, I understand.

    The UDF function yourefer to looks in a list of values and highlights values that cancel eachother like 50 and -50. You are looking for something that would highlight 100 and 2...
  12. Thread: vba form

    by sijpie
    Replies
    11
    Views
    443

    Re: vba form

    That is EXACTLY why I noted that your table 1 is not efficient for extracting the hours. When you set up a workbook you need to think about both entry of data and how you are going to use it. I will...
  13. Re: Insert picture in comment box (through fill effects → picture → insert picture)

    Yes the first two worked fine in my version of Excel which I think is also office 365. On a Windows PC.
  14. Re: Range of cells on one sheet, sorted, blanks removed and data put into a column on another.

    Dethanb, I'll look at it next week
  15. Re: Get Values in Text Box based on Check box Selection

    The following code should do the trick for the month april. You would need to add a copy for each of the checkboxes (right click on th e checkbox and select view code). Then modify the name of the...
  16. Thread: vba form

    by sijpie
    Replies
    11
    Views
    443

    Re: vba form

    I am not sure if your design for table1 is efficient for extracting the hours, but I leave that up to you. In order to record the hours I have added columns inbetween the name columns


    <tbody>
    ...
  17. Replies
    10
    Views
    115

    Re: VBA code to remove attachments

    Try stepping through the code:
    In the VBA editor, click in the sub somewhere. Then press F8 key. Continue doing this. Each statement will be stepped through. Then you can see exactly where the error...
  18. Replies
    10
    Views
    115

    Re: VBA code to remove attachments

    On my PC it runs fine. I don't know how a variant declaration could result in a user defined type not defined error. I ddi notice that one of the string variables was not defined, so I added it.

    ...
  19. Thread: vba form

    by sijpie
    Replies
    11
    Views
    443

    Re: vba form

    aboly8000,

    1. can you copy the header row of table 4 and post it here?
    2a. are the hours worked added or in this table, or
    2b. are they to be held with the worker name in a separate table as...
  20. Re: Get Values in Text Box based on Check box Selection

    Dheepak, is your userform a real pop-up userform, or is it just an area in your workbook?
  21. Replies
    10
    Views
    115

    Re: VBA code to remove attachments

    I have re-ordened your code a bit and added comments to make it easier to follow. Check out the last comment (with the <<<<). Is reprotecting the sheets really necessary, or are you going to close...
  22. Re: Insert picture in comment box (through fill effects → picture → insert picture)

    Albertan, you were right.

    Through code I can even replicate the error that you are getting!

    In the following code there are three subs. The first two work fine on my Excel, the last one gives...
  23. Replies
    10
    Views
    115

    Re: VBA code to remove attachments

    Iíll look at it on Monday
  24. Re: Insert picture in comment box (through fill effects → picture → insert picture)

    Ok I will need to test that. But itíll have to wait till Monday. For me the weekend has started
  25. Re: Index match with a variable range on a dynamic choice of worksheet

    What if you have a cell for each sheet where the number of rows on that sheet is held (using the count)

    and then instead of the 51 refer to this cell ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4