Thursday, 12 September 2013

Excel VBA programming. PLZ Solve this

Excel VBA programming. PLZ Solve this

Q # 1 i want to Write a sub procedure in VBA that either adds, subtracts,
multiplies, or divides two numbers. The procedure should be called by
another sub procedure that collects the two numbers from the user and asks
the user which mathematical operation is desired. The calling procedure
should also output the result, displaying the original values and the
answer.
Q # 2 i want to Add a few Check Box controls or Option Button controls to
a worksheet and then use a Select/Case code structure in a sub procedure
that outputs a message to the user telling him which box or option has
been selected.
Q # 3 i want to Write a program sum of following series: i.1+2+4+6……………10
ii.11+22+33+44+………99 iii.1/1+2/2+3/3+4/4……..9/9
Q # 4 i want to Write a program to find out maximum number of given three
number using input box.
Q # 5 i want to Write a program split a words given in cell D10 and show
this word one by one.
Q # 6 i want to write a program to covert the Fahrenheit temperature into
centigrade of given formula F=9/5*C+32.
Q #7 i want to Write a program to display on different cells of given
series a. Fibonacci Series b. Any tables c. Harmonic series

No comments:

Post a Comment