Is it possible to display a warning message before running a macro with a command button?

Is there a working clock that I can have on an excel worksheet? I need to input data on the hour every hour from a running total. This would make it easier if...

What I am looking for is if B7 is 19 then color the following cells in gray A7, B7, C7, D7, E7, F7, G7, and H7. How can I get this accomplished.

Hello, I am working with order forms for different types of equipment, each having its own worksheet. After selecting the appropriate sheet, I then want the...

I am trying to switch the order of words in a cell. For example I would like to switch "John Doe" to "Doe, John" in the cell next to the original. Is there...

What is the function for calculating the componded annual growth rate?

I have a macro which sequentially calls up spreadsheets from a folder then runs a macro in each sheet which involves iteration of the fourier transform...

I have a formula in one cell =e5+0.125 (The second part of the formula is hard coded) I need to separate it out to =e5 in one cell and 0.125 in another. What...

I have a table with 2 columns, 1 column contains either G, A, or Rs in them, and the other column has names. I have a formula that counts all the Gs, As and...

I am creating an invoice and would like to know if there is a way to have the worksheet create a new invoice number each time the document is...

I have a simple loan that I want to calculate the interest=20 rate for. 6 months ago I owed say =A38,000. I've paid =A3100 per month,=20 Now I owe say...

hi- i've been diddling around with format and wrap and i still cannot solve this problem. My worksheet has 2 columns in it/100 rows. i have one column with...

Hi to all and one. I have the following problem: I can find the row number by some formulas and I know the column. Is any "macro substitution" to use them for...

Hi, New to Excel and trying to figure out how to create a formula with constant and changing variables. I am trying to create a matrix where I do the...

I have a column of dates and I need to add a column that rounds the dates to the end of the quarter in which they occur. Quarters are standard -- J-F-M,...

Ihave a field that was put in as text. example 1.795 I want to change it to number. When I go to format to number, it tells me it is a number but when I go to...

I'm trying to figure out how to express two data series as a ratio, (e.g. 14:1) rather than as a fraction. Any ideas? Cheers, yao

I can only get the worksheet I was working on to appear when I go to print preview. There I have no problem zooming the sheet in or out. However, when I go...

I am trying to return results based on the time of day entered into a cell. here is an example of where I am at...