• 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. kadrleyn

    Send WhatsApp Message From Excel Sheet

    I made some changes to the Excel address book template I created earlier so that whatsapp message can be sent to the selected mobile number. - also the mobile numbers are controlled by the macro - . If the number is valid (with the international code at the beginning) and the user has the...
  2. kadrleyn

    Create Daily Sales Report With Excel VBA

    Hi, In this tutorial, we firstly created an Excel spreadsheet by entering to the Data sheet which staff sold how many products on which date . After creating the sheets showing the sales amount of the personnel, a new menu item called Add-Ins is added to the Worksheet Menu Bar. Later , a...
  3. kadrleyn

    Align Userform Next To The Clicked Cell

    It may be more useful to display this userform next to the active cell that was clicked, rather than in the center of the sheet. By declaring the GetDeviceCaps , GetDC , ReleaseDC functions , I repositioned the userform next to each the clicked activecell .(The template is checked in 32-bit and...
  4. kadrleyn

    Create Step By Step Excel Userform

    With a VBA userform, we can create a user-friendly interface for our workbook or documents . Thus, data entry to the worksheet becomes more controllable and easier. Continue reading https://eksi30.com/create-step-by-step-excel-userform/
  5. kadrleyn

    Excel AutoFilter Using Drop Down Lists

    Hi, My appeal to Norton Safe Web has resulted :
  6. kadrleyn

    Excel AutoFilter Using Drop Down Lists

    I have just requested Norton Safe Web to have my site reevaluated.
  7. kadrleyn

    Excel AutoFilter Using Drop Down Lists

    Hi, My site has an SSL certificate. I don't understand why Norton is giving such a warning. It may be due to the direct advertisement page that opens when you click on the download link.
  8. kadrleyn

    Excel AutoFilter Using Drop Down Lists

    In our template, the data in the selected column is filtered according to the selected value from the drop-down list on the userform (drop down lists are populated with unique and the sorted ascending values when userform is loaded). The text color of the cells in the filtered column is changed...
  9. kadrleyn

    Setting Userform Transparency In Excel

    I prepared an example of a userform whose transparency can be changed with Option Buttons. The transparent userform allows user to see what is in the worksheet behind the form and can make data entry more easier. Source of sample files https://eksi30.com/transparent-userform-in-excel/
  10. kadrleyn

    Right-Click Context Menu On Userform Textbox

    In template ,popup menu on textbox control is created using class module.The menu is activated using the MouseUp event of the textbox : Private WithEvents TControl As MSForms.TextBox Private Sub TControl_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As...
  11. kadrleyn

    Excel Vba Class Module Examples

    Source of above tutorial and sample files https://eksi30.com/samples-that-created-using-vba-class-modules/ Would You show Your personal links as above, that others could see - where are those linked?
  12. kadrleyn

    Excel VBA Sort Dates From Oldest To Newest

    In this template ,the records in between two specific dates easily can be filtered using drop-down lists on top side of sheet. Drop-down lists were filled with unique date values as from oldest to newest using two diffrent ways : - First way , using Adodb Connection. - Second way , using...
  13. kadrleyn

    Excel Filter Between Two Dates On Userform & Sort Dates With ADO

    In this template, I used Adodb.Connection and Adodb.Recordset to fill dates as unique into combo boxes and to sort dates oldest to newest . The filtering results that created by selecting dates (first date-last date) from the combo boxes are listed in the listbox. For i = 2 To...
  14. kadrleyn

    Add Date To Text Boxes Using Calendar Form

    A useful template about data selection & entry using option buttons on the userform , quick date entry into selected textboxes with a calendar form (Trevor Eyre's calendar form- https://chandoo.org/forum/threads/fully-customizable-vba-date-picker.19508/ ) that it is alternative to date picker...
  15. kadrleyn

    Excel Vba : Display The Pictures On Userform

    Hi, I updated the file : Source codes & sample file here
  16. kadrleyn

    Excel VBA Create New Command Bar

    Absolutely not. Only when the download link is clicked a pop-under advertisement page is opened.
  17. kadrleyn

    Excel VBA Create New Command Bar

    I created a new command bar using the macro, we added two buttons and a drop-down list to this command bar. Each control in the command bar triggers a macro. The worksheets are listed in the drop-down list. With the Update button, the drop-down list is updated, with the Sort button, the sheets...
  18. kadrleyn

    Unique Data Value Count in Excel macro needed

    Hi, Using VBA codes, I created a macro that finds the count of unique values. You can run the CountUniqueValues macro in the Macro window that opened by pressing the Alt + F8 keys. I edited and attached your file.
  19. kadrleyn

    Easy Way To Enter Date Into Active Cell

    The calendar form is displayed when it is double-clicked on any cell on the worksheet.Months are listed in the combobox control according to the user's system language starting from the month on the userform caption . The ControlTipText value of the clicked button on the userform is added to...
  20. kadrleyn

    Create Table Of Contents With Macro

    In Excel , table of contents can be automatically created a with a macro. This macro creates a new sheet named "Workbook_Index" as first sheet of workbook. The macro then lists in this sheet the names of all the sheets in the workbook and inserts a hyperlink for each one.User can be returned to...
  21. kadrleyn

    VBA Insert Picture Into Cell & View Picture It's Original Size

    Hi, Can you send me your worksheet?
  22. kadrleyn

    VBA Insert Picture Into Cell & View Picture It's Original Size

    Hi, I created a template to dynamically insert picture by cell, based on cell value, with macro. Pictures are in the same folder as the workbook. The picture is fitted in the cell where it is inserted. When the added picture is clicked, it is displayed in its original size. Source, sample files...
  23. kadrleyn

    Searchable Drop Down - Without VBA

    Hi, I just used a little Vba code to sort the data when I left the sheet where the data was taken : Private Sub Worksheet_Deactivate() Range("A2:C" & Rows.Count).Sort Range("A2"), xlAscending End Sub I created searchable lists with dynamic name and formula . Source for the build steps...
  24. kadrleyn

    Excel Date Userform -Alternative Of Date Picker-

    A good and beneficial alternative for calendar date-picker control. I have created a useful userform that it contains many features to quickly add date to the selected active cell. In the pre-selected column of the worksheet (column or columns can be selected with the codes that added to the...
  25. kadrleyn

    Filter Data Between Two Dates Using Userform

    You can find information and sample file for this template here : Source
Back
Top