• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Copy paste one sheet to another sheet

    I posted workbook to my posting in #2.
  2. L

    Copy paste one sheet to another sheet

    Here is one way : Option Explicit Sub TransposeColToRow() Dim lastCol As Long With Sheets("Sheet1") 'find the last used column on row 3 lastCol = .Cells(.Columns.Count, 1).End(xlToLeft).Column .Range(.Range("A1:A24"), .Cells(24, lastCol)).Copy End With 'paste and translose...
  3. L

    Disable Ctrl Pg Up and Ctrl Pg Dn

    You are welcome.
  4. L

    Disable Ctrl Pg Up and Ctrl Pg Dn

    Try : Application.OnKey "^{PGUP}", ""
  5. L

    Is it possible to send an automatic reminder after mail has no response within X days

    https://support.microsoft.com/en-us/office/send-an-email-message-with-a-follow-up-reminder-740a3b9e-e837-4711-938a-08dd0ea5ac64
  6. L

    VBA

    Option Explicit Sub NewestFile() Dim MyPath As String Dim MyFile As String Dim LatestFile As String Dim LatestDate As Date Dim LMD As Date MyPath = "C:\Users\Documents\" If Right(MyPath, 1) <> "\" Then MyPath = MyPath & "\" MyFile = Dir(MyPath & "*.xls"...
  7. L

    How to Convert Columns to Rows

    Here, on my machine, this is how it turned out :
  8. L

    Need help diagnosing strange behavior with strings containing "AJ"

    What about "AJ" showing "OJ" and creating a link for ESPN ? Sorry .... it was too tempting. Best wishes in your search.
  9. L

    Vba code for creating a button copy and paste

    Images are blurry, small and very difficult to read. Posting a copy of your workbook to be downloaded would help immensely. Thanks The data in Sheet 2 doesn't necessarily match up with any field in Sheet 1 ? What field/s are you copying / pasting to Sheet 2 ?
  10. L

    Week wise supervisor level attendance

    Note : The PL conditional formatting color is incorrect.
  11. L

    Number of Orders with review score 5 and payment type as a credit card.

    "and payment type as a credit card." Which column is that shown in ? What is the code for 'credit card' ?
  12. L

    I'm looking for a Macro to issue a warning when closing an excel workbook.

    The macro is to be pasted into the ThisWorkbook Module.; Download the sample workbook and open the VBA coding window. Easiest way is to right click any sheet tab and select VIEW CODE. On the left side find ThisWorkbook module and double click that. The macro code will display in the right side...
  13. L

    I'm looking for a Macro to issue a warning when closing an excel workbook.

    Option Explicit Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim Res As VbMsgBoxResult Res = MsgBox("Ensure the data matches V1 prior to closing this file." & vbNewLine & vbNewLine & "OK - CLOSE CANCEL - OPEN", vbQuestion + vbOKCancel, "Check V1 Data") If Res = vbOK...
  14. L

    How to keep msgbox in front of userform

    Untested here ... try : https://stackoverflow.com/questions/50754867/how-to-keep-msgbox-always-on-top-in-vba
  15. L

    Creating a keyboard shortcut on a new user form

    https://www.excelcampus.com/vba/keyboard-shortcut-run-macro/
  16. L

    Userform Calculations

    If it works for you, then it is proper. Having said that ... there are usually several different methods to accomplish your goals using Excel. If a challenge has 3 different methods to attain a solution, that doesn't make two of those "bad".
  17. L

    Scrolling question

    Right click the Tab for SHEET1. Left click on VIEW CODE. In the large white area on the right hand side, paste the following : Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim MyPicture As Object Dim MyTop As Double Dim MyLeft As Double Dim...
  18. L

    Code For Multiple Username And Password

    More details ...
  19. L

    How to implement an Outlook event?

    Post your code so it can be reviewed.
  20. L

    VBA Macros Protection

    https://spreadsheet1.com/unviewable-vba-project-app-for-excel.html
  21. L

    How to keep msgbox in front of userform

    Sorry .... I don't have an answer for you. :mad:
  22. L

    how to show excel tab (not a cell, Shift+10 it is not) right click menu without a mouse

    Your keyboard should already have a key that performs this action. Read these two resources : https://chandoo.org/wp/right-click-from-the-keyboard-not-the-mouse/ https://chandoo.org/wp/replace-formulas-with-values/
  23. L

    How to keep msgbox in front of userform

    Sorry you are not receiving the same results there. With my single monitor I was able to specify the userform be centered on the screen, then the msgbox would visualize over the userform. The userform must be "ShowModal = False" in the settings. Paste in the UserForm : Option Explicit...
Back
Top