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...
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...
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...
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/
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.
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...
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/
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...
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?
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...