Art of Excel

Art of Excel The "Art of Excel" is the is hub for MS-Excel related trainings in Delhi and NCR. We are a group of very experienced VBA & Excel trainers.

17/10/2022

We are happy to come back to your service again. Reachout for Advanced as well basic cources on the Art of Excel

13/07/2014

What is the output of this following code if: -

1) Cell A1 has "Art of Excel" written in it
2) Cell A1 has 12345 written in it
3) Cell A1 has "12345" written in it and
4) Cell A1 is blank

Comment your answer.
********************************************************************************************

Private Sub errMsg(err_text As String)
MsgBox "Error : " & err_text & " !"
End Sub

Sub test1()
If Range("A1") = "" Then
errMsg "empty cell"
ElseIf Not IsNumeric(Range("A1")) Then
errMsg "non-numerical value"
End If
End Sub

13/07/2014

What is the correct way to declare a 2D string type dynamic array in VBA?? Comment your answer.

a) Dim arr2D()() As String
b) Dim arr2D( , ) As String
c) Dim arr2D() As String
d) Dim arr2D(5,5) As String

Call today to join next batch +91-7042141938
04/07/2014

Call today to join next batch +91-7042141938

03/07/2014

Setting Alignment for Cell Content:

You can align data in a spreadsheet cell with these two properties - HorizontalAlignment and VerticalAlignment. These properties can be used with ActiveCell, Range or Cells. The valid values for HorizontalAlignment are as follow:

xlCenter
xlLeft
xlRight

For VerticalAlignment the valid value are:

xlBottom
xlCenter
xlTop

Have a look at the following code examples to understand how it works.

ActiveCell.HorizontalAlignment = xlCenter

ActiveCell.HorizontalAlignment = xlRight

ActiveCell.VerticalAlignment = xlBottom

25/06/2014

We have new presence on web - www.artofxl.blogspot.in . Please keep visiting it for new tips and tricks. We will be publishing articles there which will really help you in becoming an expert in excel

25/06/2014

Question from member - Vishal

Sub ifcondition()
Dim a As Integer
a = InputBox("Enter a no between 1to7")
If a = 1 Then
MsgBox ("monday")
If a = 2 Then
MsgBox ("Tuesday")
If a = 3 Then
MsgBox ("Wednesday")
If a = 4 Then
MsgBox ("Thursday")
If a = 5 Then
MsgBox ("Friday")
If a = 6 Then
MsgBox ("Saturday")
If a = 7 Then
MsgBox ("Sunday")
Else
MsgBox ("Holiday")
End If
End Sub
I'm getting an error blockif without Endif

How many of you are able to spot the problem?

What do you do when you have to create an excel document from scratch with lot of data ?1) Look for a template on net2) ...
25/06/2014

What do you do when you have to create an excel document from scratch with lot of data ?
1) Look for a template on net
2) Look for template in excel
3) Ask some friend to help out
4) Code Macro to design a template

Join us to become master of Excel Macros and VBA Programming
21/06/2014

Join us to become master of Excel Macros and VBA Programming

18/05/2014

How many Strings can be concatenated together in excel in one formula?

In how many ways can you get the sum of squares of numbers between B3 to B9?? You can write your formula in the cell E6 ...
14/05/2014

In how many ways can you get the sum of squares of numbers between B3 to B9?? You can write your formula in the cell E6 only.

11/05/2014

Question for all Excel Lovers :
What is the difference between command "Find" and "Search"?

Address

Delhi
110092

Telephone

+919910374900

Website

Alerts

Be the first to know and let us send you an email when Art of Excel posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Art of Excel:

Share