Hi,

I am learning Excel VB programming. It is quite easy. But I don't get how to use custom function in here?

Public Function gradeCal(gpa As Double)
            If (gpa >= 5) Then
                Return "A+"
            ElseIf (gpa >= 4) Then
                Return "A"
            ……
End Function

Hi,

I am doing some work with Excel. I am not much familiar with VB but the Excel macro seems easy and interesting. I have yet used MsgBox and buttons to do almost everything. The Excel sheet was the main window which is used as a form for hosting the other stuffs.

For example if i need 3 data to input I use something like

x = InputBox("enter the value", "Its the title")

3 times.

Now I think it would be cool to have my custom popup messages/forms for doing all these. But how do I do this? Please help.

Hi

I have been playing around with Excel a few days. It is really a nice tool. I can do a lot of calculations here with less effort. I have also heard that it is possible to do some programming with excel too. So i thought i will try.

Here is what I want to do first.

My present sheet has 7 columns each are having a value (cash amount) in each of them. The 8th column holds the following equation:

=SUM(A1:C1)/3+SUM(D1:E1)/2+F1+G1              

So it gives the summation of the left 7 columns. The equation changes from A1 to A25 , depending on the row number.

Hi,

I have an Excel application that is just a simple crude database for my coffee shop. There is a form which takes order and prints the Receipt. We have 3 types of coffee in the shop and we are increasing. Currently, in the form we have to add the whole name “Black” , “Light”,  in the type field to create the receipt properly.

I want a drop down box there which will have all the types, so I can just select it from there. How can I do this? I am not an Excel expert, nor even a programmer. I hired a student to make this Excel file for me which I copy-paste every year.

I can see the code and that is very interesting! So I thought that maybe I can do this little tweak. It may be possible if you help!

Hi there,

I have developed an Excel VB sheet to generate transcripts. The application is simple. But I don't know how to print the page with macro. Currently, I just copy-paste the generated transcript to Word and print it manually. This is not looking much professional. So  I would like to make it automated.

Please help.

Hi everyone,

I recently downloaded a PowerPoint show file from the internet. I want to edit the contents and make my own PowerPoint. How do I do this? When I double click it the PowerPoint show runs without opening it inside Microsoft PowerPoint.

Hi,

I am using Microsoft Office Excel 2007, but I do not have enough skills in Excel. That's my main problem – I do not know how to classify different data and sort them according to my wants.

Mainly I need help in the field of Filtering Data. How does it work? Moreover, I will be glad if anyone tells me how I can write formulas to sort my data easily.

Excel is a very important software for me, as I have to work with it regularly. Can anyone tell me the meaning of those formulas used in Excel?

I want to know how those formulas work. I have tried to understand this but I couldn't. Those formulas can make my work easy, so it's very important for me to know how these formula work.

Hi,

I just got my Internet service connected with Time Warner and got my personal email address from them. I want to set it up with Microsoft Outlook but I don't know how it is done.

Can anyone guide me or show me screenshots on how can it be done?

I have a set of images in JPG format. I have Microsoft Office installed. I need to extract the text off the JPG files. How do I do this?