tag:blogger.com,1999:blog-76499404550739064242024-03-15T07:11:41.468-07:00New Ideas For Computer & SoftwareExcel tutorial ,excel vba programming, excel advanced templatesKadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.comBlogger148125tag:blogger.com,1999:blog-7649940455073906424.post-27184859572153308932020-06-07T14:25:00.008-07:002022-02-11T01:19:13.029-08:00Create A Simple Userform In Excel
Building An Excel Userform
Excel Userform is a custom created dialog box that we build using the Visual Basic Editor (VBE).
With a userform, we can create a user-friendly interface for our workbook or document .Thus, data entry to the worksheet becomes more controllable and easier.
Now let's see how to create a simple userform to enter personal spendingKadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com2tag:blogger.com,1999:blog-7649940455073906424.post-67552790951279581732020-04-01T11:17:00.003-07:002022-06-30T13:55:30.006-07:00Destroy The Blocks In Excel
//<![CDATA[
function open_win() {
window.open("https://www.onclickperformance.com/jump/next.php?r=3403783", "ad");
}
//]]>
Excel Destroy The Blocks Game
A nice game that to spend time at home from due to corona virus.
Destroy the blocks by making vertical, horizontal, or diagonal lines of the same colour by arranging the falling Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-22451954265375613422020-03-28T11:56:00.000-07:002020-05-10T08:07:41.836-07:00Excel Formüller
Excel Formül Kullanımı
Hücreler tek tek A1, A2,, B1, B2, C1, C2, şeklinde veya birden çok hücre iki nokta işaretiyle adreslenebilir. Örneğin A1 hücresinden C6 hücresine kadar hücrelerin adreslenmesi A1:C6 şeklindedir.
Ardışık olmayan alanların seçili olduğunun gösterilmesi ise A1:C6;D1:F6 şeklinde seçilihücre Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-50943192222102322192020-03-27T15:08:00.000-07:002020-07-16T13:53:52.631-07:00Excel Define Dynamic Named Range
//<![CDATA[
function open_win() {
window.open("https://www.onclickperformance.com/jump/next.php?r=3403783", "ad");
}
//]]>
Excel Dynamic Named Range
Dynamic named range has advantages over normal named range. For example ,the dynamic named range expands automatically when user added a value to the range.
To define dynamic named range ;
➤ Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-38240600385176299752020-03-17T14:55:00.003-07:002021-11-21T00:25:16.128-08:00Excel Alfabetik Sıralama Formülü
Excel Sütunu Formül İle Alfabetik Sıralama
Excel formülleri kullanarak , A sütunundaki verileri F sütununa alfabetik olarak (A-Z) sıraladık.
İlk olarak , Formüller Ad Yöneticisi menüsünden A2:A16 hücreleri için Liste adında bir isim tanımladık.
Tanımladığımız Ad : Liste=Sayfa1!$A$2:$A$16
Daha sonra sütundaki verileri Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com3tag:blogger.com,1999:blog-7649940455073906424.post-73178536999521058532020-03-03T03:24:00.000-08:002020-07-16T13:55:52.192-07:00Excel VBA Delete Repeated Rows
Excel Delete Duplicate Rows Based On Multiple Columns
➤ In this template, there are records that contain values in the rows between column A and column M.
There are rows with exactly the same values, namely the repeated rows. We will delete duplicate rows with the same content as the macro that we created.
To run the macro;
✔ By Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-79517639569870887692020-01-24T12:26:00.000-08:002020-04-22T12:40:18.991-07:00Entering Numbers That Start With A Zero
Entering Numbers That Start With A Zero In Excel
Excel won't display the leading zeros by default in cell.
When user entered the leading zeros, Excel applies the General numeric format and removes out the leading zero. Excel won't display the leading 0 digit .
As a solution, the following ways can be applied :
➪ An apostrophe character (') is put precede Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-13392695121728911512020-01-08T02:12:00.003-08:002021-10-27T00:55:51.269-07:00Chemical Elements In Excel
Excel VBA Chemical Elements Table
We created a table of chemical elements in Excel workbook. We have added a simple Excel userform to make it easier to review the properties of chemical elements.
Our userform has a combobox, a button and text boxes .We vocalized the selected element name from the combobox and atomic number with the VBA Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-44161320462359093762019-12-28T12:49:00.001-08:002021-09-28T12:41:41.030-07:00Find The Repeated Data On The Sheet With Count Of Repetitions
//<![CDATA[
function open_win() {
window.open("https://www.onclickperformance.com/jump/next.php?r=3403783", "ad");
}
//]]>
As sample, data in Column A was used in this Excel VBA Template.
When the button is pressed,the repeated data in "Column A" are listed into "Column G" and "Column H" with the count of
repetitions.
Our Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-19181381996428813672019-12-26T12:00:00.002-08:002020-05-22T13:47:05.126-07:00Show Only One Column
Show Only The Selected Column With Dropdown List
Suppose you have a worksheet with a lot of columns. There are headers in Column A, other columns of sheets have data.
You want column A to remain constant, and you want to see one by one next to column A to examine the other columns.
We have prepared a userform for thisKadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-51961319660699277342019-12-22T12:26:00.000-08:002020-06-19T00:34:56.442-07:00Excel Number To Text Function
Convert A Numeric Value To Dollar & Cents Currency
A useful Excel function.
We created a NumbertoText function in VBA Module1. Our function converts the number to dollars and cents currency.
The function can be used on all worksheets of the workbook.
For example, enter "75,30" into cell G1, and enter the Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-25563989241549901412019-12-04T11:53:00.000-08:002020-06-19T00:35:37.835-07:00Copy & Paste Macro
Excel VBA Copy & Paste
B7,C7,D7 and E7 cells in Invoice sheet are copied into blank rows in the Data sheet.
Our VBA codes that we used in the template:
Private Sub CommandButton1_Click()
Dim son As Long
If Sheets("Invoice").Range("B7") = "" Or Sheets("Invoice").Range("C7") = "" Or _
Sheets("Invoice").Range("D7") = "" Or Sheets("Invoice")Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-21298544636862672472017-10-27T02:39:00.000-07:002020-05-17T09:21:29.434-07:00Animation Of The Colors With Excel VBA Codes
Excel animation with voice and music prepared with Excel VBA codes
to learn Spanish colors.
When clicked on the color circles, the animation of clicked
color starts A 3D cylinder was selected as the animation item.At the end of
the animation, the name of the color is played and a child laughing effect is played using playing function. Spanish
Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-62842318804511138382017-10-17T01:19:00.000-07:002020-05-17T09:22:50.729-07:00Excel VBA Dictionary (Catalog) Form
Excel VBA Dictionary Userform
✎ It can be used as an application such as dictionary, index.
For example, we entered the names of the vitamins to column
A and entered descriptions of vitamins to column B.
The data in column A of the sheet is filled to the combobox
on the userform.
The value corresponding to the item selected from the
combobox is fetched Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com3tag:blogger.com,1999:blog-7649940455073906424.post-21123745783221918712017-10-06T01:19:00.003-07:002021-11-18T00:28:49.198-08:00Excel VBA Animation Examples
Excel Animations That Created With VBA Codes
Simple and instructive animations for those who want to learn the Excel programming. Macro codes of the animations can be viewed in
the workbooks.
⇨ Generally ,the shapes in the worksheet are moved with Vba codes and loops.
⇨ Let's review an VBA animation sample :
🔊 Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com1tag:blogger.com,1999:blog-7649940455073906424.post-66289087152611340052017-09-17T23:46:00.001-07:002021-11-01T13:42:38.826-07:00Display The Pictures On Userform
Display The Pictures On Userform & Picture Management With Userform
In this tutorial, with userform, you can add and delete new images to the workbook folder.
As an example, we added the workbook and some images to a folder. When the userform is loaded, the names of images with .jpg extension in the folder are sorted on the listbox.
Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com2tag:blogger.com,1999:blog-7649940455073906424.post-42679614729976665262017-05-29T08:01:00.001-07:002022-02-27T11:39:08.703-08:00Play Musical Notes In Excel
Excel VBA Play Music Notes
Musical notes (piano notes) can be played with buttons and functional keys in Excel.
✓ Ago, we added buttons to the worksheet .Then ,we assigned the macros to these buttons to play the music notes(.wav files) that are in the same place as the workbook. Example ;
Private Sub CommandButton2_Click()
Call Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-16990878821683103022017-05-17T10:34:00.002-07:002021-12-09T12:29:40.621-08:00Find Data Between Two Dates In Excel VBA
Excel VBA Find Data Between Two Dates
Records in between two specific dates easily can be filtered
using drop-down lists .
Ago ,drop-down lists (combo boxes) were filled with unique values as ascending order using ADO connection. Thus, it is easier to choose between the dates on the worksheet. The used codes for this :
Set con = CreateObjectKadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-25233811065815399382017-04-06T10:25:00.001-07:002020-05-18T12:29:00.629-07:00Create Simple Dynamic(Dependent) Drop Down Lists In Excel
Excel Dynamic Drop Down Lists
In worksheet, we can create dynamic drop down lists with the
Data Validation feature and the Indirect function.
In sample sheet,we have a table of five columns that indicate five types of foodstuff: fruit, food, meat,vegetable and drink and below them are the specific food name :
We Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-91744299655056642642017-03-05T11:44:00.004-08:002022-05-05T13:31:31.162-07:00Creating Invoice And Entering Data Quickly Through Userforms
Excel Automated Invoice With Userforms
In this invoice template ,the userforms that contains
textbox,listbox and buttons are used to enter quickly data of customers and
products:
✔️ Addition and multiplication operations in column G are performed through formulas (=E21*F21, =SUM(G21:G35) etc.) The used Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com1tag:blogger.com,1999:blog-7649940455073906424.post-2109785725704132402017-01-25T09:43:00.000-08:002020-05-18T12:46:45.596-07:00Excel VBA Games : Find Matches | Rocket Throwing | Tetris
Fun Games Created With Excel VBA Codes
Simple and fun VBA games that can be played inside the Excel worksheet.
There are three games in three separate workbooks:
Find Matches : In the game , you need to find the same colored cells by double-clicking on the cells.
Rocket Throwing : Press "Enter" key, the rocket moves, and passes through the Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com1tag:blogger.com,1999:blog-7649940455073906424.post-88584303317582751952017-01-04T04:57:00.001-08:002020-07-17T13:36:09.387-07:00Excel Convert HEX To RGB
Excel VBA Convert HEX To RGB With Userform
Hexadecimal(Hex) color codes frequently are used in web designing
(HTML-CSS etc.) .
In Excel, the RGB and HLS color codes are used. Therefore, it is necessary to
convert Hex values to RGB or HLS.
For example,consider we have a hexadecimal code for a cell
background Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-85820757140156524682017-01-02T10:06:00.001-08:002020-03-13T14:05:36.770-07:00Creating A Separate Sheet For Each Month With Macro
Excel VBA Create The Separate Sheet For Each Month
When "Create Month Sheets" button in worksheet is clicked, new sheets (12 sheets) are created for each month and added in workbook.
Namely months of the current year are ordered as sheets.
📅 Days of each month are listed in Column A as "dd.mm.yyyy". Today's date is selected from between dates.Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com1tag:blogger.com,1999:blog-7649940455073906424.post-54260428282147877752016-12-21T09:20:00.000-08:002020-03-13T14:07:42.731-07:00Excel Flashing Cell
The Flashing Cell When Certain Condition Is Met
In our example, if the value of cell A1 is greater than 5, this cell starts to flash. The flashing event is realized by changing the background color and font color of the cell at a particular time (firstly red ,then white color) .
We added a module to ensure the cell Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0tag:blogger.com,1999:blog-7649940455073906424.post-11626045437091858032016-12-04T11:33:00.001-08:002020-08-03T12:09:34.860-07:00Excel Change Background Color of Selected Cells With Scrollbar Control On Userform
Excel VBA: Change Cell's Background Color With Userform
The userform starts as automatically when the worksheet is opened .Background color of selected cells can be changed with VBA scrollbar control on this userform.
The scrollbar's min value is 0, the maximum value is 56.
The related VBA codes:
Private Sub CommandButton1_Click()
Unload Me
End Sub
Kadr Leynhttp://www.blogger.com/profile/12302763575988103568noreply@blogger.com0