Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.12 seconds.

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

    it had slipped my mind. if I have some time I'll get back to it
  2. Re: Range of cells on one sheet, sorted, blanks removed and data put into a column on another.

    I do not understand at all what you are trying to do with the pieces of code you are showing. Anyway, the following code does the trick. Basically I have added an array to hold the font colour of the...
  3. Re: Range of cells on one sheet, sorted, blanks removed and data put into a column on another.

    Where do you want to check for the font color? Do you mean if any of the names are in color other than black they should not be added?
  4. Re: If value selected before,Then remove from the data validation list VBA

    The following should do the trick.

    I have also cleaned up your original code a bit, see the comments.


    '==========================
    Private Sub Worksheet_BeforeDoubleClick _
    (ByVal Target...
  5. Re: If value selected before,Then remove from the data validation list VBA

    A few questions:


    Do you have more than one validations where you want to delete an entry after selection? ie Are there more columns with different validation sets?
    Are the validation sets...
  6. Re: Need to understand if I need loop or something else to have DB react on input action

    If you still need help, I can look at it middle of next week. Let me know
  7. Replies
    1
    Views
    77

    Re: Trend cursor on Excel Chart

    try with googling on "mouse-over excel chart"

    and another good chartin source is Jon Peltier
  8. Re: If value selected before,Then remove from the data validation list VBA

    I sometimes do this. By using the Worksheet_Change event when the user has selected one of the validated entries, the macro stores the current validation entries in an array and then loops through...
  9. 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...
  10. 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.
  11. 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...
  12. Replies
    1
    Views
    136

    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,...
  13. Replies
    1
    Views
    140

    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
  14. Replies
    1
    Views
    149

    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...
  15. 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...
  16. 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...
  17. Thread: vba form

    by sijpie
    Replies
    11
    Views
    518

    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...
  18. Thread: vba form

    by sijpie
    Replies
    11
    Views
    518

    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...
  19. Replies
    3
    Views
    241

    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...
  20. Thread: vba form

    by sijpie
    Replies
    11
    Views
    518

    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...
  21. 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.
  22. 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
  23. 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...
  24. Thread: vba form

    by sijpie
    Replies
    11
    Views
    518

    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>
    ...
  25. Replies
    10
    Views
    144

    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...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4