I want to change the icon showing in the left top most of the excel to my own icon.
Can anybody help me for the same.

I need an excel expert that knows a shortcut that will allow me to convert the follwing formula =+'[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L181+'[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L317 to =+'Staff Plan - FY13'!L181+'Staff Plan - FY13'!L317

I have created this formula but it is giving the result "0", when if fact what should showing is "2", even in the formula checker I gone through it systematically and it only results in "0", this is based on the $c87 cell content being a No.4 and the AV80 cell content being a No.1. I know it is to do with a true/false statement but because of the nesting the formula reading right but results wrong and I can't seem to correct it - can anyone see what I done wrong and point out the error I have made! to me thank-you

If you want to give Christmas look or use custom shapes instead of in-built markers on charts. Snapshot below-

Download Working File/Macro - https://www.box.com/s/02sfon6jloo7lpaj3s6c

Steps to use -

Download the working File
=> Goto “Data” sheet . Change chart data as per your requirement , series name,etc.
=> Add custom shapes to excel sheet which you would like to show instead of markers

Download and try Calender in Excel. Snapshot below-

Download Link https://www.box.com/s/fe5hfdixf5eldknxnz7l

Steps to use -

1 Download the file
2 Add the reminders in "Reminders" sheet
3 Select the month from the drop-down on "Calender" sheet
4 Choose Year using scroll bar

Thanks Andy that does work.
Instead of dropping a hyperlink onto th worksheet, and executing from there, I'd prefer to have it execute directly from the User Form upon clicking on the option. In other works, click and the button and it directly goes to the website, then returns to the user form (same one or next) without having to return to the spreadsheet itself. Make sense?
Pat

Is there a way to call up a URL from within a sub, and when done, return to the sub? In my routine I want to have a choice to "Check in wikipedia" but what id any coding will do this?
Pat

Función SIFECHA:
Esta función devuelve la diferencia entre dos fechas, expresada en determinado intervalo.

Esta función es un caso aparte, no por su simpleza o complejidad. Simplemente, porque desde Excel 5.0 no está documentada. Es una función  que si la buscamos en el listado de funciones de Excel, veremos que no aparece.

1. I am using excel2003 & i want to set some text in e column 32 no row that can not be delited, if any one delete that column or row, that text again appair at same place.

2. i want to block arrow key (near right ctrl key), how?

Please help me.

Thanks

So you want to become a Microsoft Excel MVP ?

Well, there's no exact formula to this journey but I might be able to offer a few tips on things that will help your case. Becoming a Microsoft Excel MVP is about being an expert in Excel, volunteering your expertise, and being known for your contribution. You cannot apply for this award, and you need simply to be recognised.

Here are a few things that might help to get you noticed:

Dos:

In my Laptop installed version of Ms-office 2007, every opening of Ms-excel,
once "PERSONAL.XLS" also opening with excel file. please help me how to
deactivate my normal excel file..

I have the entire layout done, I just need a great deal of help in making my coding correct so I can make it run properly. I have included all the steps needed in order to complete it and want to make sure I'm headed in somewhat of the right direction but I am struggling greatly. Any help would much appreciated.

Design and code a project to calcu¬late the amount due for rentals.
Movies may be in VCR (videotape) format or DVD format
Videotapes rent for $1.80 each and DVD’s rent for $2.50.
New releases are $3 for DVD and $2 for videotape.

Martin,

two files attached. MD master is the file which collates the data from the timesheets. TS1 is a timesheet. Note I have amended the timesheet format slightly so this will need to become your new template timesheet (see notes).
I recommend you error check for mathematical errors before deploying.
The master workbook also has a populateallrnd macro which will populate all timesheet workbooks within a folder with random numbers.
Any probs/questions email me at andrewlitchfield@gmail.com for fine tweaking

Attached is a simple spreadsheet for calculating linear and binomial coefficients using Excel

 Function HdNum() As String

    Dim fsObj   As Object

    Dim drv     As Object

    Set fsObj = CreateObject("Scripting.FileSystemObject")

    Set drv = fsObj.Drives("C")

    HdNum = Hex(drv.serialnumber)

End Function

Sub HD()

    MsgBox HdNum

End Sub

Since each computers hdd serial number is unique this can be useful for security

Just a bit of fun to demo how you can create a scrolling dot matrix message display using a bit of VBA and charts.

Sub DotMatrix()
Dim lngIndex As Long

ColourNum = 3
ColourSelect

DispState = Sheet2.CheckBox1.Value
Sheet2.CheckBox1.Value = True

Sheet2.Range("C58").Value = 1
'Exit Sub
With Worksheets("LCD")
For lngIndex = 0 To (Len(.Range("DISPLAYTEXT").Value) * 6) Step 1
.Range("SLICE").Value = lngIndex
Range("C2").Select
DoEvents
Next

Hi all

ExcelExperts continues to go from strength to strength thanks to our fantastic volunteers.

Top Volunteers at the moment are manny, Argyronet and almir 

Suppose you have the list of web URL's which are redirecting to new URL. To find the redirect/ new URL try this UDF-

Function redirect_url(surl As String) As String

Dim myIE As Object
Set myIE = CreateObject("InternetExplorer.Application")
myIE.Navigate surl
Do While myIE.Busy
Loop
redirect_url = myIE.Document.URL
myIE.Quit
Set myIE = Nothing

End Function

Hi,
Please can someone assist me with my code below, i am tying to get this to work, i input data in one sheet and then want to store the data in another workbook, if i save the data to the same workbook the code works fine, but when i attempt to save to another workbook, it records the data but does not close the workbook, i am also looking at sending this out to multiple users, have researched so many alternatives but none seem to work, there is talk about ADO but my knowledge is low on that...hoping that someoone can help with this...

Private Sub Auto_Open()

If you want to select the first cell after freeze pane on each worksheet and save it. So that when user opens the workbook he/she do not have to press CTRL+ Home in each worksheet to go to first cell.

Here is the code -

Sub goto_first_cell_in_each_worksheet()
Dim wk As Worksheet
For Each wk In ThisWorkbook.Worksheets
If wk.Visible = xlSheetVisible Then
wk.Select
If ActiveWindow.SplitRow = 0 And ActiveWindow.SplitColumn = 0 Then
Application.Goto Range("a1")
Else

If you want to know the first cell after the freeze pane . Try this code-

Sub find_first_cell_after_freeze_pane()
If ActiveWindow.SplitRow = 0 And ActiveWindow.SplitColumn = 0 Then
MsgBox "No freeze Pane Found"
Exit Sub
Else
MsgBox Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Address
End If
End Sub

This is a reply to forum topic "Search, Copy & Paste macro.":

 excelexperts.com/search-copy-paste-macro

Download an example file to see the solution.

If you want to add a new button on mouse right click menu "Worksheet Navigation" showing the list of worksheets in active workbook and navigate easily.

Private Sub Workbook_Open()
On Error Resume Next
'Delete the new button if already exists
' name of the new button is "New Button"
Application.CommandBars("Cell").Controls("Worksheet Navigation").Delete
'run a macro to add a new button on mouse right click
Call add_new_button
End Sub

It is amazing how many people use Excel for providing status updates, reference material, defect tracking, etc. I have made a number of solutions for Excel users that thought that Excel was just a bunch of cells that could do a few calcs for convenience (SUM, IF, Vlookup,etc.) I think the hardest thing about Excel is getting the users to understand that excel can do things better. For example: a users mantains a list of somekind with each record containing several attributes.

I made a UDF in Excel 2010 which is programmed to give an output in acordance to the value of the transfered parameters, for the best display I need to be able to modify the output format in correspondence with the results, the question is:

Is it possible to include, as a part of the UDF, a code to make a conditional format to display the result in an appropriate format? if so, how can I program it?.

To illustrate the question take this: functionName(A,B,C,D,E)

where A,B,C,D are the parameters for the calculus and E is the format parameter, for example:

In this file you can find excel translation from spanish to english

How can we hide tabs (such as home, insert etc) in excel through VBA automatically .

I am trying to figure out how to create a nested if/and statement with 5 conditions but I either get an effor telling me it is not a valid equation or it tells me I have too many conditions. Below is the formula.

Essentially I would like the cell to tell me, based on the five conditions, if it is less than or more than fair market rent for the size of unit (0-4 bedrooms) and the corresponding rent standard.

Here is my statement

This is a reply to forum topic "Checkbox help":

 excelexperts.com/checkbox-help

Download an example file to see the solution.