You are reading the article Extreme Programming (Xp) In A Nutshell updated in November 2023 on the website Tai-facebook.edu.vn. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested December 2023 Extreme Programming (Xp) In A Nutshell
Extreme Programming (XP)Placed in the late 1900s, software development and programming concepts saw a considerable change in the way and approach of the entire schema. The development of computer software was changing as more leaner and pocket-sized methods gained popularity, and developers began applying explicit unitized models. There should be a reduction in wastage with the increase in demand for efficient systems, and thus, the era of methodologies for efficient software development came to rise. Object-Oriented Programming soon replaced procedural programming, and the waterfall model made way for Agile to take over the lead. Japanese quality control frameworks were quickly gaining momentum. Then emerged the concept of something previously used in bits and pieces but now a full-fledged methodology for solving software programming and development woes, Extreme Programming!
Start Your Free Project Management Course
Project scheduling and management, project management software & others
What is Extreme Programming (XP)?Implementation of extreme programming enhanced software quality and responded more efficiently to the changing business requirements caused by scaling of companies or external factors.
XP is a methodology under the Agile umbrella that encourages frequent version releases in short development cycles. It would inevitably increase productivity significantly, and the regular releases would pave the way for incorporating newer requirements.
Extreme Programming (XP) has “customer satisfaction” at the heart of its framework and “teamwork” as the muscle power. Collaboration is necessary for extreme programming (XP) to succeed as it takes iterative steps toward producing software for clients/customers. At every stage along the way, it focuses on fulfilling the client’s needs rather than delivering the entire belt.
Part of Agile Software DevelopmentAgile software development is the undertaking way of development, but most importantly, most people forget to acknowledge that teams, that is, people, need to be Agile to succeed. The methods and processes implementation only ensures that there is a fixed framework in which teams can be flexible, scalable, and more definitively creative.
Agile provides a great platform to implement changes and feedback in each development cycle that passes by, thanks to the concepts of iteration and sprints, as seen in the case of Scrum.
When it comes to Extreme Programming (XP), it considers all the opportunities that can result in improvements made to the product at the end.
Traditional Development versus Extreme Programming (XP)
While traditional development focuses on the process and considers it when it comes to the completion of the cycle, extreme programming focuses on the requirement.
Extreme Programming (XP) takes the best practices installed in traditional development to the outer limits. The stretching with extreme programming (XP) is excellent for flexible and elastic projects.
5 Values for a Successful ProjectExtreme programming (XP) involves the five important ways or values of heading toward a successful software project:
Communication – This software development methodology requires intimate contact between the managers, clients/customers, and developers. To ensure the smooth functioning of the software project, the team implements effective communication and utilizes other project management tools within it to facilitate the project life cycle.
Courage – With dramatic changes in customer requirements, the developers must courageously undertake the challenges that crop up at the last minute or contradicting modifications applied to the project at any time.
Implementation of Feedback occurs through constant unit testing, and the results are evaluated and accordingly implemented within the project development chúng tôi team presents a demo to customers as soon as the development cycle is completed to incorporate feedback, with customers being at close quarters.
Respect – Each development cycle brings with its success to a new milestone, and it only exemplifies the contributions put into processes undertaken.
Simplicity – extreme programming (XP) is most efficient when the design is kept simple and implementation planning is clear and effective. A lot of extreme programming rides on the simple rules it has in place.
Planning-Feedback CyclesCollaboration in the team and daily connection to the business for optimized product development form the backbone of extreme programming (XP), while user stories form the basis of XP planning. Jot down these user stories on cards. Manipulating these cards can bring to life the project scope and plan.
These XP planning are created with three levels or tiers.
Future months
Next iteration
Current iteration
Plans are always temporary; before the end of the last program, make the recreation of methods. They change as and when there is even a slight change in the project or its schedule. The iteration starts at the occurrence of evolution. You gain feedback from the customer; you revisit your plan. You stand ahead or behind schedule; you review and change your plan.
Through planning, the most appropriate designs for the product to be delivered come into effect. Use Extreme programming (XP), Test-driven development (TDD), and refactoring for effective and efficient designing.
Already having the essence of Agile, refactoring is an essential and crucial design tool involved in the planning process. Refactoring involves making design alternations and adjustments in accord with the altered needs. With refactoring comes the concept of testing in a unitized and acceptable manner.
Each step in the sequence can be iterative and looped as and upon the initiation of the change sequence and a recreation of a new plan for each initiation. Each step also has a particular duration, and there is a schedule for the rest of the feedback for each stage of the product.
Coding to Pair Programming – seconds
Pair Programming to Unit Testing – minutes
Unit Testing to Pair Negotiation – hours
Pair Negotiation to Stand-up Meeting – one day
Stand-up Meeting to Acceptance Testing – days
Acceptance Testing to Iteration Planning – weeks
Iteration Planning to Release planning – months
With the level of iteration sought after, it becomes mandatory for the developers to ensure and assure that code is of optimum quality. Reporting bugs is a strict no-no for developers following the extreme programming methodology for software development.
What is Pair Programming?As the central resource to the extreme programming methodology is people and not processes, people run the concept of pair programming. Adding productivity and quality to the table, pair programming goes something like this:
“The code sent into production is created by two people who work together on the code to be created while sitting on a single computer.”
The benefits of this concept of pair programming are as follows:
Enhanced software quality – while there is no addition in functionality with two people sitting together or apart, concentration on a single computer adds to the quality of the code rendered.
Cost savings for later stages – with the high-quality code already rendered, the impact it has on later stages is enormous, and there are savings in the cost with each iteration.
Pair programming, as it involves two distinctive individuals working together at equal tables, it becomes essential for them to coordinate at a higher level, irrespective of the level of experience. It’s a social skill that takes time to learn, and it needs two dedicated professionals that want to make a difference in the world of software development.
RulesWhile we know that the rules put to work in the world of Extreme Programming (XP) are based on the principle and value of Simplicity, having a good view of these rules makes up an excellent methodology within software development techniques.
PlanningWithin planning, the project manager and his team look at the requirements thoroughly and adhere to the following rules:
Jot down User stories.
Release planning should result in a release schedule
Split the project is split
Releases need to be frequent but small
Iteration planning should start the iteration
ManagingManaging the tasks allotted and the duration for each peculiar task is the role of the project manager. It’s essential that the project manager is mindful of the risks and adherence of each stage undertaken by the team members and steers the workforce and resources accordingly to fulfill the concept of extreme programming (XP). Here are some of the rules that need to go through a PM:
The team should receive an open workspace to extend their imagination
The schedule allotted should be realistic and carefully paced
Each working day should commence with a stand-up meeting
Collaboration and teamwork are major components and need the utmost encouragement
Measure Project Velocity during each change incorporation
Move around People.
Steering extreme programming (XP) is quintessential and initiates planning at each opportunity for change.
DesigningDesigning is the stage that carefully follows planning and determines the handling of requirements at the project’s initial phase. A good design reflects the thought process and creativity and calls for fewer iterations, thus, ensuring high levels of quality at the very start of the project. Being a reflection of the planning stage, here are a few rules to keep in mind during the implementation of designs in extreme programming (XP):
Simplicity is key
Do not introduce functionality at an early stage
Refactoring is essential at every step to provide efficient and effective product designs
Use Spike solutions to reduce the number and intensity of risks in the software project
CodingOnce the design is in place, it’s time to get all hands on deck and give the go-ahead for creating and generating code that will enter production for testing and delivery. Coding is the stage that demonstrates the actual functioning of the project methodology and encourages iteration most effectively. Here are quick rules to be mindful of when in the coding stage:
Customer needs to be in the loop at all times during product releases
Code must adhere to coding standards and practices adopted worldwide
Code the unit test as the start
Production code should undergo pair programming for high quality
Integrate principles often and should be done by one pair only at a particular time
Share accountability, and promote intensive teamwork
Pair programming should take place on one computer
Preferable seating of the pair should be side by side
TestingWith the code ready and rolling, testing is a seal of the smooth functioning of the code lines. Testing forms as a seal stamp, ensuring software preparation for consumption. Following are the rules put in place for testing within Extreme Programming (XP):
A code should contain unit tests.
A release would require codes to pass these unit tests
Create tests for the detection of bugs
Acceptance tests should have a high frequency, and results should be published.
Users shouldn’t detect any bugs within a code.
When to Use Extreme Programming (XP)?Extreme Programming was born due to the need to work around a project that carried a lot of changes at many junctures in time. It became necessary for the methodology adopted to be iterative and straightforward at its core. The following are the situations that can ask for the use of extreme programming (XP):
Customers don’t have a good idea about the system’s functionality
Expect Changes are dynamic to change after short intervals of time
Business is steeply rising
Resources allocated are the bare minimum; no huge staff
Need a considerable increase in productivity
Risk needs high levels of mitigation
High provisions for testing
So, here’s extreme programming (XP) for you in brief and simple words. This methodology has reported success in all software development undertakings and has had a great success rate throughout its implementation history. Born out of standard and simplistic requirements, extreme programming (XP) is now slowly gaining recognition as a methodology.
You're reading Extreme Programming (Xp) In A Nutshell
Excel Football Dashboard Extreme Makeover
Here is the ‘Before’ photo:
Every number in the league table above is hard keyed except for the ‘Totals’ rows! EVERY NUMBER.
Not only that, each week he had to manually rearrange the order of the teams as rankings changed, and update the colour coding for the teams that moved up or down.
No wonder it took 2 hours to update every week.
All that manual work is an Excel crime!
When we heard about this we thought it was a prime candidate for an ‘Excel Dashboard Extreme Makeover’.
So I put on my Dr Dashboard mask and nipped and tucked his league tables into shape.
And here is the ‘After’ photo:
Note: The after photo shows the current season’s teams and divisions which are slightly different to the before photo from last season, but I think you get the gist. It’s much better, right?
In complete contrast to the original league table every number is now the result of formulas that automatically recalculate. EVERY NUMBER.
Not only that, the teams are automatically sorted based on their new rankings and the colours and symbols also automatically change with the help of Conditional Formatting.
It now takes Darryl 10 minutes to update. In reality it could take 2 but he uses one finger to type.
It’s Excel heaven! Actually, it’s the way Excel was intended to be used.
Anatomy of the DashboardHopefully you’re not squeamish because I’m going to take you into the gizzards (as my kids say) of this new league table dashboard so you can see how it works.
Note: Even if you’re not interested in football, there are some great lessons here on different tools you can use in Excel and how to tie them together to make a dynamic and informative report.
So back away from the mouse and keep reading 🙂
Download
Download the workbook and follow along. Use it for your own league tables, reverse engineer it and see how it works, or print it off and make a paper plane, whatever tickles your fancy!
Enter your email address below to download the sample workbook.
By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.
Source DataLike I said, previously all of the data was hard keyed except for the ‘Totals’ row which was only there for checking that he’d keyed everything in correctly. It was good to see that he’d built in cross checks.
With the new league table he simply enters the fixtures and scores for the week into a source data sheet for each division. The Premier division looks like this:
You might be thinking, phew that’s a lot to key in, but in reality he already has almost all of this data for the fixtures draw. Formulas in the Result Home and Result Away columns return the W, L or D (win, loss, draw), so nothing to enter there.
By the way, the W, L or D feeds the Match History conditional formatting in the league table. More on that in a moment.
WorkingsThe league tables are fed by two sets of workings in columns to the right; one for the current week (columns AG:AR) and one for the previous week (columns AT:BD partially outside of image):
In columns AH to AM and AR I’ve used SUMPRODUCT formulas, but you could also use SUMIFS and COUNTIF(S) to return the results.
P – Played SUMPRODUCT or COUNTIFS
W – Won SUMPRODUCT or COUNTIFS
D – Draw SUMPRODUCT or COUNTIFS
L – Lost SUMPRODUCT or COUNTIFS
F – Goals For SUMPRODUCT or SUMIFS
A – Goals Against SUMPRODUCT or SUMIFS
No Ref – SUMPRODUCT or COUNTIF
GD – Goal Difference is simply column AL – AM, and the PTS (Points) are referencing the values in cells AP2:AR2 located above the workings tables.
I’ve used the RANK function (column AQ) to rank the teams in the League Tables from top to bottom.
Note: because there could be ties I’ve first calculated a ‘Unique PTS’ in column AP which is weighted to avoid a tie on Points (PTS). It does this by also using the Goal Difference (GD) and an alphabetical ranking in the calculation.
The League TablesThe Rank result is then used in a VLOOKUP formula with CHOOSE to return a sorted list of teams in column A of the league table.
Tip: we use CHOOSE to get around the limitation of VLOOKUP not being able to lookup to the left. You could also use INDEX & MATCH.
Fonts and Conditional Formatting
Now, you might have wondered earlier why we need workings for the current week and previous week…well that’s because we need to show which teams have moved up, down or stayed the same from one week to the next.
I’ve done this with some wingding fonts in column B, and Conditional formatting is used to highlight the team’s row red if they moved down, blue if they moved up and black if they stayed the same.
Match HistoryThe match history is also conditional formatting.
An INDEX and MATCH formula looks up the ‘Result’ columns on each division’s source data sheet and brings in the W (win), L (loss) or D (draw) for each week. Conditional formatting colours the cell green (W), red (L) or grey (D).
The challenge with this formula is that because the order of the teams shuffles each week the Match History also needs to shuffle to stay aligned to the team’s new position in the league table.
Zebra StripesDid you notice the Conditional Formatting Zebra Stripes on the source data sheets?
The blue and white alternating lines allow you to easily see the records for each week’s fixtures grouped together in banded blue/white lines.
You can learn how to do Zebra strips in varying numbers of rows here.
Group ButtonsI have used Group Buttons to hide the spare rows for each division. This allows the dashboard to be re-used from one season to the next and allow for changes in the number of teams.
I prefer to use Group Buttons to hide/unhide rows and columns as I find it quicker to toggle between them being hidden or unhidden.
More on how to group and outline data here.
Want More?Do your reports take hours to update like Darryl’s did?
If you’d like to learn how to create dynamic reports like this that take just a few minutes to update, then check out my Excel Dashboard course where I teach these techniques and more.
ThanksThanks to Roberto for helping me make my Match History formula more elegant.
Top Programming Languages Powering Fintech Applications In 2023
Analytics Insight has listed major programming languages that are changing the face of fintech
The
Top five programming languages for fintechJava C++ C++ is a cross-platform language that can be used to create high-performance applications. It is an object-oriented C++ was developed by Bjarne Stroustrup, as an extension to the C language. The magic of C++ is that the language is closer to machines than other programming languages, making its frequency very high. In the C++ programming and that makes the language a must be known for job seekers. Haskell Haskell is a widely used functional programming language that is based on mathematical functions. The language is named for Haskell Brooks Curry, whose work in mathematical logic services as a foundation for functional languages. Extraordinary features like a balance of flexible and inflexible qualities make Haskell a fascinating programming language to learn and use. Programmers can now relieve themselves from writing large software systems, thanks to emerging Python Python is an interpreted, object-oriented, high-level SQL
The fintech industry across the world is very receptive to disruptive technologies. The increase in transaction rates and the low risk on tolerance have surged the need for applications that can streamline the banking process. Unfortunately, before employing the applications directly on fintech , we need to develop or program them. Banks have been directly connecting with IT firms or hiring programmers to carry out the job. The programmers are expected to be well versed in programming languages . Programming is the process of writing instructions for a computer or an application to perform. Even though they don’t expect the candidate to know all programming languages , the professionals should at least be fluent in some of them. When programmers work on a fintech projects, they should consider technical and business requirements and the banks’ specific needs. Analytics Insight has listed major programming languages that are changing the face of fintech in 2023 Java is a general-purpose, class-based, object-oriented programming language designed for having lesser implementation dependencies. It is one of the most used programming languages that are also featured in the computing platform. Java was first released by Sun Microsystems n 1995. It is well known and fast adopted for its secure and reliable features. Remarkably, the fintech industry is embracing java to power its systems and applications. Java also offers everything companies in fintech need to develop robust apps that customers can rely on to assist with their requirements. It is openly accessible in a variety of OD platforms including iOS, Android, Windows, Linux, and others. Henceforth, Java carries the luxury to provide companies with an extensive audience base without necessitating expensive investments. Java’s extensive features like Java Virtual Machine leverages byte code, type safety, garbage collection, etc that helps companies entrust the language for fintech apps.C++ is a cross-platform language that can be used to create high-performance applications. It is an object-oriented programming language that gives a clear structure to programs and allows code to be reused, lowering development costs. C++ is famous for its portable accessibility that is used to develop applications that can be adapted to multiple platforms. Besides, it is also simple in the sense that programs can be broken down into logical units and parts, and has rich library support and a variety of data chúng tôi developed by Bjarne Stroustrup, as an extension to the C language. The magic of C++ is that the language is closer to machines than other programming languages, making its frequency very high. In the fintech industry, a good number of programmers use the C++ language. Most of the professionals in fintech are also good atprogramming and that makes the language a must be known for job seekers.Haskell is a widely used functional programming language that is based on mathematical functions. The language is named for Haskell Brooks Curry, whose work in mathematical logic services as a foundation for functional languages. Extraordinary features like a balance of flexible and inflexible qualities make Haskell a fascinating programming language to learn and use. Programmers can now relieve themselves from writing large software systems, thanks to emerging programming languages like Haskell that make it easier and cheaper to develop applications. Fintech companies use Haskell because of its properties that imperative programming doesn’t provide. It is also great in handling blockchain, immutability, type safety, and the ability to manage distributed computation well.Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. It is widely adopted by programmers for its high-level build-in data structures, combined with dynamic typing and dynamic binding. Besides, it can be easy to pick up for both first-timers and well-experienced programmers. Python also provides increased productivity that programmers look for in a programming language. It was created by Guido van Rossum, and released in 1991. Python rose to popularity and has been demonstrated by numerous financial companies after job postings required the language from developers since 2023. Widespread across the investment banking and hedge fund industries, banks are suing Python to solve quantitative problems for pricing, trade management, and risk management chúng tôi is also known as Structured Query Language, is a standard language for accessing and manipulating databases. It features database creation, deletion, fetching rows, modifying rows, etc. Even though SQL is an ANSI (American National Standard Institute) standard language, there are many different versions of the SQL language that has emerged from the core. It can also perform exclusive operations like optimizing and maintaining databases. For a fintech company, SQL is used to analyze consumer data. Doing so will help them identify seasonal variations in demand or consumption patterns.
Awesome To Build Web Development Apps In Go Programming
Introduction to Web Development Apps in Go Programming
Welcome to my next blog, fellow go programmers. In this blog, we will be talking about Google’s awesome Golang language. In my previous blog, you might have seen how Golang has evolved over the years and has given tough competition to Java and C++. But in this blog, we would be talking about its real-world applications. Golang is Google’s official programming language.
Start Your Free Software Development Course
Web development, programming languages, Software testing & others
Google has kept its license Open source. It means that anyone can modify, copy, paste or change it as per their needs. Golang is a high-level programming language. However, Go has a lot of characteristics similar to C or Java; it’s hardly anything like either C or Java.
In fact, Go Programming was intended to be a language, which could be a combination of Python, C and Java. Even though it can never replace these languages, but still other languages cannot do what Go can, and to speak the truth, it’s actually much faster than C or Python. Enough about how GO programming works now; let us see the real-world applications of it besides being of a lot of help to Google and how it has actually dominated the world of web development.
Through out this blog, I will be assuming that you have some basic knowledge in programming C, Java or atleast Django. If not, you can read my other blogs to understand it and then come back here and continue with this one.
The Go Programming Language Example Origin of GORemember I told you that Go received its characteristics from web development languages like C and python, but the truth is, it actually borrowed a lot than just characteristics. It has the agility of the compilation speed of python without losing the safe polarity of C. The miniature builds of GO are spot-on; for example, you can compile large programs in just seconds. The speeds of these bytecodes are almost similar to that of the C’s.
The main reason GO Programming was developed because Google had very large data critical servers and the programmers invested, or the better term would be wasted, long time waiting for the programs to compile. Even though the code was compiled and parallelized, it still took a very long time to build a single program.
Even incremental builds were slow (Incremental builds means just updating old builds with new features or cleansing its bugs). It was then they realized that they need something different, something with the power of C and the speed of python. They also decided the tools used in these basic systems language were slow.
So they wanted to start something from scratch, something to write those kinds of programs that they needed to write at Google in a way that the builds could be really smart and short without losing their efficiency.
Web development, concurrencies, and GONow the thing is, how does web development work with GO? How does it gain from its concurrency? The thing is, theoretically, with parallel processing, the server’s resources could be put to better use. For example, if you run 2 independent sql queries in parallel, it will give a quick response. Isn’t this amazing?
Now, let us take a look at this the other way round.
So, unfortunately, this develops a lot of hiccups on our way, which is actually not good because concurrency can lead to a better visual arrangement and clearer code. In short, it can be relied on for one reason, which you wouldn’t want: low-performance. But, inspite of all this, we are actually ignoring the main part. If we actually have a good set of hardware or faster computing techniques to be more precise, GO would actually work faster in a multi-core processor environment.
Now let’s take a look at how GO is different from other languages. We need to do step one: pick any global mutable state that you wish to change, then step two: implement locking. Now, this is a combination of two proper steps and two wrong things. Developers that have decent experience would agree with me that a global mutable state is a bad thing.
As a matter of fact, many coders try to remove this in the best way possible. So the utmost fact that you have step one looks like some refactoring is in order, to begin with. Step two, on the other hand, i.e. locking, is capable of achieving its goal, but at the same time, it introduces gigantic amounts of boilerplate that is extremely hard to write it down in a proper manner and then debug it correctly.
The Way to GOConcurrency and the channels; both go together hand-in-hand in GO programming. It can, however, be said that these channels have the real horsepower to make our automation work. And because of this nature, they prevent the routines in GO from being duplicated. Nuf said, now you can run your codes without the help of locks and mutexes. If you have the time worth googling, you will find many people trying the same methods in the form of UNIX pipes.
Building native GO AppsNow that we know how GO works let us look at building some basic Applications in GO. Let us go through the Pre-requisites first:
Download the go installer from the official go website (you can get it by searching download golang)
Set the GOPATH (This is the most tricky part if you have never set environment variables in your life)
a. For Windows Usersset GOROOT=C:go
set GOPATH=C:Userstestdir
set GOBIN=%GOPATH%bin
set PATH=%PATH%;c:gobin;%GOBIN%
cd %GOPATH%src
b. For Linux Usersexport GOROOT=/usr/local/go
export GOPATH=$HOME/go
export PATH=$PATH:$GOROOT/bin:$GOPATH/bin
Following are the required packages that you would need to download (these are optional, depends upon what you need to build):
You can install (or update) these packages by running the following command in your console:
For example, if you want to install Negroni, then you can use the following command:
For me, building web applications mean building Http servers. Http or Hypertext Transfer Protocol is a protocol that was originally built to transport only user-specific HTML documents from a specific server to a client-side web browser. As of today, Http is used to transport more than just plain texts.
I won’t be getting in deep; actually, you can refer to github where you can find more details about this project.
Now to get you started, let us begin by creating a new project in our GOPATH
mkdir testserver
cd testserver
Now, we can create a chúng tôi by typing:
package main func main() { }The whole Program will then look like this:
package main func main() { }Now to execute and make our fileserver live, we can run it whenever we want by typing:
go build
./testserver
Speaking of which, you should actually check out the web applications developed in github, and you will be actually astonished to see what all apps people have developed with GO programming. GO language is more than just your regular programming. Once you get the hang of this language, it is highly unlikely that you will actually go to back to your regular C, C++ or Java. So, that will be it as for now. Stay tuned for more on GO programming.
Recommended ArticlesWe hope that this EDUCBA information on “go programming” was beneficial to you. You can view EDUCBA’s recommended articles for more information.
How To Use Resize Property In Excel Vba Programming?
Excel VBA Resize
VBA Resize is a method where we use it to highlight the cells by changing their size for visualization. The important thing which needs to be noted is that this method is used only for illustration purposes. Resize is a property that is used with the range property method to display the selection of rows and columns provided as an argument concerning a given range.
Watch our Demo Courses and Videos
Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.
Syntax of VBA Resize:
The syntax for this property is as follows:
Row size is the number of rows we want to select or highlight, and column size is the number of columns we want to select and highlight. This property needs a reference to a range. If one of the arguments from row size or column size is not provided, this function selects the entire row or the column from the range. The methods to use Resize property in VBA are as follows:
First, we need to provide a range for reference.
The next step is to provide the arguments for the rows and size for resize property.
To illustrate it, we need to use the select property method.
Using the Resize Property in Excel VBAThe following examples will teach us how to use Resize Property in Excel using the VBA Code.
You can download this VBA Resize Excel Template here – VBA Resize Excel Template
Example #1Let us first begin with the essential resize property. In this example, we will see how to use resize the property and how we need to provide the inputs for this resize function in general. For this, follow the below steps:
Step 2: Now write the sub-procedure for VBA Resize.
Code:
Sub
Example1()End Sub
Step 3: Resize is a range property of VBA; let us select a range.
Code:
Sub
Example1() Range("A1")End Sub
Step 4: After that, we can use the dot operator and resize method to select the number of columns and rows.
Code:
Sub
Example1() Range("A1").Resize(RowSize:=2, ColumnSize:=2)End Sub
Step 5: We can use the select method property for illustration purposes.
Code:
Sub
Example1() Range("A1").Resize(RowSize:=2, ColumnSize:=2).SelectEnd Sub
Step 6: Run the Code by hitting F5 or the Run button and see the result in worksheet 1.
We have selected two rows and two columns for the range.
Example #2In the above example, we have used the same number of rows and columns for the range. Let us try a different approach and use diverse selection such as row size to be 3 and column size to be 2. For this, follow the below steps:
Step 1: We can use the same Module and begin with our sub-procedure for the second example.
Code:
Sub
Example2()End Sub
Step 2: As this is a range property, we will use the range method to reference a cell.
Code:
Sub
Example2() Range("A1:C4")End Sub
Step 3: Then, we will use the resize method and select the row and column size for the arguments.
Code:
Sub
Example2() Range("A1:C4").Resize(3, 2)End Sub
Step 4: The final step is to use the Select property method for the illustration.
Code:
Sub
Example2() Range("A1:C4").Resize(3, 2).SelectEnd Sub
Step 5: When we execute the above code by hitting F5 we can see the following result in sheet 1.
Out of the range A1:C4, this code has selected three rows and two columns.
Example #3So in the above examples, we saw how to resize property works if there is the same number of rows and columns or a different number of rows and columns as the argument. Now let us see what happens when we do not provide one of the arguments to the function. For this, follow the below steps:
Step 1: Declare another Subprocedure.
Code:
Sub
Example3()End Sub
Step 2: Now, we can select any random range.
Code:
Sub
Example3() Range("A1:C4")End Sub
Step 3: Now, we will use the resize property, but we will remove the row specification from the code.
Code:
Sub
Example3() Range("A1:C4").Resize(, 1)End Sub
Step 4: Now, we will use the select method.
Code:
Sub
Example3() Range("A1:C4").Resize(, 1).SelectEnd Sub
Step 5: Run the Code by hitting F5 or the Run button.
It selected one column but the entire four rows.
Example #4Step 1: Let us begin with a sub-procedure in the same Module.
Code:
Sub
Example4()End Sub
Step 2: First, we activate sheet 1 using the worksheet property method.
Code:
Sub
Example4() Worksheets("Sheet1").ActivateEnd Sub
Step 3: Now, let us provide the selection with the number of rows and a number of columns using the selection property method, as shown below.
Code:
Sub
Example4() Worksheets("Sheet1").Activate numRows = Selection.Rows.Count numColumns = Selection.Columns.CountEnd Sub
Step 4: Now, we can use the resize property to increase the selection by two rows and two columns.
Code:
Sub
Example4() Worksheets("Sheet1").Activate numRows = Selection.Rows.Count numColumns = Selection.Columns.Count Selection.Resize(numRows + 2, numColumns + 2).SelectEnd Sub
Step 5: So here is our selection before the execution of the code.
Code:
Step 6: When we execute the code.
The following code extended the selection by two rows and two columns.
Things to RememberThere are a few things that we need to remember about VBA Resize:
This is a range property method.
It illustrates the selection of rows and columns from a given range.
The first argument in this function is a row reference, and the second argument is a range reference.
If one of the arguments from row size or column size is not provided, this function selects the entire row or the column from the range.
Recommended ArticlesThis is a guide to the VBA Resize. Here we discuss how to use the Resize property in Excel VBA, practical examples, and downloadable Excel template. You can also go through our other suggested articles –
Learn Core Java Programming Language
Java Tutorials and Guide
Java is a high-level programming language developed by the sun microsystem. First, it was conceived by James Gosling, Patrick Naughton, Chris Warth, Ed Frank, and Mike in the year 1991. Initially, it was named “Oak,” and it was renamed “Java” in 1995. Java is a highly object-oriented, platform-independent, and secure programming language.
One of the most important factors in the java programming language is its Bytecode conversion. Byte codes in Java are a highly optimized set of instructions designed to be executed by Java Virtual Machine. JVM works as an interpreter for the byte code.
We require JDK (Java Development Kit) to use java programming language, including JRE (Java Runtime Environment).
Why do we need to learn Java?
Simple: Java is designed in such a way that a programmer can easily learn and use it effectively. If a programmer is aware of some basics of Object-Oriented Programming, learning java will be easier.
Object-oriented: In Java, everything is an Object. Java was not designed to be source code compatible with any other languages. This benefits a clean, usable, and pragmatic approach to objects. It can easily extend since Java is based on the object model.
Platform independent: Unlike other programming languages, java code is not converted to platform-specific Machine language. Rather java code is converted into platform-independent Bytecode, and JVM interprets it.
Multithreaded: Java meets the requirement of creating interactive and networked programs. Java supports multithreaded programming that allows writing programs that perform various tasks simultaneously.
Robust: Running java program on multiplatform environment and executes reliably. Java has a strictly typed language. Therefore, it checks java code at compile time and runs time.
Architecture neutral: Java designer’s main goal was “write once, run anywhere, anytime. The changes in the Platform or in the machine do not affect the java code.
Distributed: Java is designed to run on a distributed environment or Internet because it handles TCP/IP protocol, and it also supports Remote Method Invocation.
Applications of JavaJava is used in various application developments following are some real-time applications of Java.
Desktop GUI applications: Java provides the facility to develop Graphical User Interface-based desktop applications by various means like AWT (Abstract Window Toolkit), Java Swings, and JavaFX. AWT consists of various components like menus, buttons, and text boxes. Etc…JavaFX is a media package that provides 3D graphics.
Mobile applications: Advanced java technology – Java 2 Micro Edition is a cross-platform technology that provides to develop of applications that run on any platform, i.e., Java-supported devices like mobile phones or smartphones. And recent technology of android is also scripted in Java with other APIS.
Embedded System: Embedded electronic devices ranging from tiny chips to large electronic gadgets like refrigerators, TVs, and large electromechanical devices are coded in Java.
Enterprise Applications: Java Enterprise Edition supports to development of enterprise-level applications like banking. JEE provides APIs and a runtime environment for scripting.
Web Applications: Java Advance technologies like Servlets, JSP, and Struts support the development of web applications. Using these technologies, a programmer can develop highly secure web applications that are easy to code.
Simple Java ProgramCode:
public class SimpleExample1 { public static void main(String[] args) { int a = 10; System.out.println("Hello……EDUCBA"); System.out.println("Value of a = "+ a); } }Output:
PrerequisiteTo learn java programming, a language programmer should have prior basic knowledge of any programming language such as C. Since Java is a purely object-oriented language, basic knowledge of any object-oriented language like C++ is necessary, and it becomes easier to understand Java. The only programmer needs to understand the basic syntax and structure of the java programming language.
Target AudienceStarting from the java standard edition, it’s a greater beginning for java programmers Standard Edition support to develop, ranging from Desktop applications to embedded systems. Advanced java version, i.e., J2EE technologies, support to develop Enterprise level applications, web applications, gaming applications, etc.
Update the detailed information about Extreme Programming (Xp) In A Nutshell on the Tai-facebook.edu.vn website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!