Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: a MACRO to populate headers on worksheets??? Code listed

    .
    The following macro will create only the headers. You can add the other code formatting, etc ...



    Option Explicit
    'headers are in rangers B2 through B10
    Sub EntrHdrs()
    With...
  2. Re: Creating a sleep/wake log - need to calculate average sleep and wake time

    Format the time cells as h:mm;@ AM/PM

    The user will enter time in this manner : 9:15 PM and the time will be displayed as 21:15

    Or : 9:15 AM and the time will be displayed as 9:15

    They...
  3. Thread: gpa calculator

    by Logit
    Replies
    3
    Views
    275

    Re: gpa calculator

    Great ! Cheers ...
  4. Re: Download over 1 million rows from data.cms.gov

    .
    Download complete txt file : https://www.amazon.com/clouddrive/share/WrQfnjhCjdlokqmYaHMbMuw72naixV9P1EOxOkq44RL

    Open with NOTEPAD, copy all, then paste into Excel. It will auto separate into...
  5. Re: attach current unsaved workbook to email using vba and cc

    You are welcome.
  6. Re: attach current unsaved workbook to email using vba and cc

    Option Explicit


    Sub Email_Sheet()


    Dim oApp As Object
    Dim oMail As Object
    Dim LWorkbook As Workbook
    Dim LFileName As String
  7. Replies
    2
    Views
    49

    Re: Input Photo Macro

    Is the workbook saved before being sent in an email ?
  8. Re: Displaying a userform message at a future date and time read from values in a sheet

    .
    I don't know what to advise as it works here as expected.

    If you haven't changed anything in the download workbook ... the only thing that might be different is how the date and time
    is being...
  9. Re: Excel splash screen animated dots on loading

    .
    http://www.kubiszyn.co.uk/download/free/Blue%20Bubble%20Loader.xls
  10. Replies
    12
    Views
    152

    Re: Unwanted Message - Can't Find the Source

    .
    One thought .. if your macro code has the line "On Error Resume Next" ... or if it has a call to an error handler .... disable those. Then run the code and see
    if it errors out on a line of code...
  11. Replies
    3
    Views
    61

    Re: OnKey with Msgbox

    You are welcome.
  12. Replies
    3
    Views
    61

    Re: OnKey with Msgbox

    Paste this into a regular module :



    Option Explicit


    Sub ShwMsg()
    MsgBox "This is restricted.", vbCritical, "Error"
    End Sub
  13. Re: Displaying a userform message at a future date and time read from values in a sheet

    .
    The code is yours to do with as you need to. Except make a profit off of it. :)

    Not certain why the macro won't run in your environment. Note that there are macros in the regular module,
    the...
  14. Re: Automatically e-mail a client when first part of project is done in Excel?

    https://www.rondebruin.nl/win/s1/outlook/mail.htm
  15. Re: Displaying a userform message at a future date and time read from values in a sheet...

    .
    Updated download : https://www.amazon.com/clouddrive/share/gz4mTvOQ4ZU64ZFaenKVviaapZq2sUHyqm2y73DcIjF
  16. Re: Displaying a userform message at a future date and time read from values in a sheet

    .
    Look at the download.

    - Changed the date / time entry

    - Auto sorts all entries by date & time so they are always in the correct order

    - When dismissing the current message, the...
  17. Re: Displaying a userform message at a future date and time read from values in a sheet

    .
    Once the message has been displayed .... can it be deleted from the sheet ?
  18. Re: Displaying a userform message at a future date and time read from values in a sheet

    .
    Brainstorming ...
  19. Re: Displaying a userform message at a future date and time read from values in a sheet

    How many pending messages do you envision for any single day ?
  20. Re: Displaying a userform message at a future date and time read from values in a sheet

    .
    Your last post has created questions which leads me to believe you did not accurately describe the goal in your first post.

    Do I now correctly understand you are wanting to use a USERFORM to...
  21. Re: Displaying a userform message at a future date and time read from values in a sheet...

    .
    Paste in a regular module :



    Option Explicit


    Dim TimeToRun
  22. Replies
    5
    Views
    158

    Re: save to a area & create a backup too

    You are welcome.
  23. Replies
    7
    Views
    186

    Re: Need help in solving the below scenario

    .
    You are welcome.
  24. Thread: Help :)

    by Logit
    Replies
    1
    Views
    79

    Re: Help :)

    .
    Your original post wherein Fluff provided code suggestions ... you indicated you only wanted to copy data and not delete empty rows/cells.

    This somewhat matches your intermittent issues of the...
  25. Replies
    7
    Views
    186

    Re: Need help in solving the below scenario

    .
    As the question was posted :


    =IF(B1<0,"0",IF(B1="Exempted","Null",IF(B1="Not Reached","Null2",IF(B1>70,"40",IF(AND(B1>0,B1<70),"20","")))))

    Blue Hornet raises several valid points.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4