Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    10
    Views
    92

    Re: VBA: Popup message based on scenarios

    I presume Points are consistently displayed to the same number of decimal points in each message string.
    So replace the line which calculates the variable initially. This rounds to 2 places ...
    ...
  2. Replies
    7
    Views
    103

    Re: Convert a list into rows

    If you are happy with a VBA solution ....

    The function below will ultimately be called from another VBA procedure if it works as expected when you test it


    First of all give this a try in a...
  3. Replies
    1
    Views
    36

    Re: VBA is Adding Microsoft Excel Objects??

    Does the workbook contain any VBA?
  4. Re: PERSONAL.XLSB has Disappeared - Please Help

    this may help
    https://support.office.com/en-ie/article/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790
  5. Re: PERSONAL.XLSB has Disappeared - Please Help

    MARK858 is correct

    You should be able to find that workbook here:
    Excel 2016 - C:\Users\"user name"\AppData\Roaming\Microsoft\Excel\XLStart\
    Excel 2013 - C:\Users\"user...
  6. Re: msoFileDialogFilePicker not opening as expected

    Agreed - same behaviour on my PC

    So I tested

    .ButtonName = "LongNameThatMakesBiuttonWider"

    The button:
    - is now wider,
    - shows caption "LongNameThatMakesBiuttonWider" (very briefly -...
  7. Replies
    10
    Views
    92

    Re: VBA: Popup message based on scenarios

    Something which may (possibly!) avoid you being confused by Select Case when you modify the code

    VBA exits Select Case on the FIRST found match

    The police are never called in example below...
  8. Replies
    10
    Views
    92

    Re: VBA: Popup message based on scenarios

    To convert value to absolute, use VBA function Abs
    Abs(value)

    The tests must continue to use the true values in the cells
    To avoid repeating the formulas in EVERY message string
    - create 2 new...
  9. Replies
    10
    Views
    92

    Re: VBA: Popup message based on scenarios

    This line declares variables used in the code. It specifies the TYPE of value held in each variable

    Dim msg As String, Points As Double, Ranking As Double

    Numbers can be type Double, Single,...
  10. Replies
    10
    Views
    92

    Re: VBA: Popup message based on scenarios

    Yes
    - add the line you correctly deduced and immediately below that a line it to build the message string
  11. Re: Search a phrase in a sheet then display that phrase in the cell

    With the 4 phrases in A1:A4 in sheet containing the formula, and searching for phrases in Sheet XYZ

    =IF(COUNTIF('Sheet XYZ'!1:1048576,A1)>0,A1,
    IF(COUNTIF('Sheet XYZ'!1:1048576,A2)>0,A2,...
  12. Re: Incompatible decimal separator for VBA autofilter

    glad it helped
    thanks for the feedback
    :beerchug:
  13. Replies
    7
    Views
    103

    Re: Convert a list into rows

    That data in post#3 does not look like a typical UK adddress list (no counties??? etc)
    - simplifying to that extent may be unhelpful :warning:

    We need to understand what the actual data looks...
  14. Replies
    7
    Views
    103

    Re: Convert a list into rows

    EDIT - just spotted that you have posted some data


    Name and address lists are notoriously inconsistent and error prone so I endeavour to FIX data layout to make it more consistent BEFORE trying...
  15. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    Perhaps this link will help
    https://www.syvantis.com/blog/how-to-disable-autosave-in-office-365-programs
  16. Re: Incompatible decimal separator for VBA autofilter

    Try


    With ActiveSheet.ListObjects("Table1").Range
    .AutoFilter Field:=8, Criteria1:=Range("N10").Value2
    End With

    and read...
  17. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    Consider starting a new thread to help resolve OneDrive issue - others have probably suffered similarly :banghead::banghead::banghead::banghead:
    Good luck
  18. Replies
    10
    Views
    92

    Re: VBA: Popup message based on scenarios

    There are other possible outcomes that you omitted
    What happens if either or both values = 0
    Amend VBA below to cover all eventualities


    Sub Test()

    Dim msg As String, Points As Double,...
  19. Replies
    37
    Views
    1,184

    Re: Help Centering Image VBA

    - the new line will only work where stated previously
    - simply replace the one line with the other
    - the function must be placed in the same module as the code which is making use of it
    - place it...
  20. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    please read this AFTER reading posts #14 to #17

    Final contribution for today - some of this has now become "pseudo-code simply there as a bit of a guide :warning:

    Calling the userform to...
  21. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    Please read post#14 onwards before reading this

    Which message is next?

    Here is the simplest way I can think of to return the correct "next" message each time

    With column D = message status &...
  22. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    Please read post#14 onwards before reading this

    Sorting messages

    The UserForm adds items with various dates and times to sheet "DATA"
    Those items are added in the order created
    Below is a...
  23. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    Please read post#14 before reading this


    Has every message been dealt with?

    Application.OnTime is reliant on the macro being active at the correct time but that will not always be the case
    ...
  24. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    You have already developed this tool much further than I realised and I have been unnecssarily solving the "whole" picture rather than trying to provide you with the bits you need to fit into what...
  25. Replies
    20
    Views
    351

    Re: Asking for help on a variable input for Application.ontime...

    Ah .... that requires a re-think on my part - sorry I must have missed something earlier.

    I was gong to dump all messages with same time to the same message box
    - which will obviously not work...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4