Search results for query: *

I just tried when you before i saw your post, yes, it works perfectly. thank you very much.

*************************** Sub whats_that() MsgBox ActiveCell.Value End Sub *************************** i ran the above code, the message box showing "0".

Hi John, I did mention what I am trying to do in my prior post. the exactly formula i am using in a cell C1 is: =IF(AND(ISBLANK(A1),ISBLANK(B1)),"---"),IF(AND(ISNumber(A1), ISBLANK(B1)),"100%",IF(AND(ISNUMB ER(A1),ISNUMBER(B1)),(A1-B1)/B1,""))) since A1, B1 have formula, the ISBLANK...

well, Master!B2's formula is =SUM(W6:Y11). the each cell in this range has formula also, for example, W6's formula is "=O22", O22's formula is "SUM(C8:C21)".

Here is what I am trying to do: Col A Col B Col C Row1 27 100% Row2 --- Row3 50 20 120% Cells A1, A2, A3, B1, B2, B3 all have fomulas. Situation 1: A1 has value, B1 is empty, C1 shows 100%; Situation 2: A2 is empty, B2 is empty...

I tried LEN function. if A1 is empty, Len(A1) returns 1; If A1 has value 1, Len(A1) also returns 1.

well, the formula is very complicated. for example, i am checking whether A1 is empty: A1 = C1; C1 = "Sheets!D1" D1 = Sum(P1:Q10)" I am just giving you one example of how the formula looks behind. And I am dealing with many cells like this situation, and each cell somehow link to a cell...

Yes. I did try ISBLANK.

Hi, How can I catch an empty cell? the cell has a formula which reference to another cell. I tried isblank(A1), didn't work; I tried trim(A1) = "", didn't work; I tried len(A1) = 0 (returend 1), didn't work. Can anyone please help? what i try to accomplish is if A1 is empty, B1 shows "---"...

Thank you for your reply. I am doing as you suggested. I deleted all the new formula I added to it then added back one at a time then run it, save it. so then i can find out which formula failed on me... :(

I have created a report. the main report will pass some values to a subreport. the subreport is showing all the details for each record. It worked fine. And i was working on it today. when i tried to refresh data and move page by page, when it reached to page 10, i received the error window...

Well, when to call the macro to replace the words is ondemand by user not me which means they would like to run this macro anytime they want to change the words.

Let me make my question clearly: I am trying to write a macro to replace a word from a template but not in text formields. For example, I have a checkbox, and put a description next to this check box as "Exceeds Expectations". now I want to run the macro to replace "Exceeds Expectations" with...

Gerry, I tired. But if there are "Exceeds Expectations" in text formfields which is user entered and suppose not be replaced was replaced with "Excellent" also.

Hi, I am using a macro to search one word and replace it using a different one. For example: Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "Exceeds Expectations" '20 .Replacement.Text =...

Thank you so much for your reply and all the good suggestions. yes, i just can't redesign this template since they want to either show the new face or the old face just by changing one date field... I did create 2 different templates for them and user can run a macro to open one template by the...

-------------------------------- Why not just have text explaining the checkbox beside the checkbox? I may be missing something here. --------------------------------- Gerry, I am not very good at designing Work template. this is the one i am taking over from someone else. you are right that...

I guess maybe the best way to slove the checkbox issue is delete it when user entered date less than 11/1/2006, then add it back when the date is > 11/1/2006. do you know how to add the check box next to a text formfield? thanks

the reason I need to hide one check box is because the template is using by user now. it has check boxes for user to choose. Now user wants to type in a date to decide: if the date they entered is before 11/1/2006, they still want to see the 2 check boxes, but if after that day, they don't want...

Hi, Questions 1: I am having 2 check box formfields in a Word template. when user entered different infor, there is one checkbox need to be hidden. How can do this? Question 2: By default the text form field's background color is gray, can i change it to other colors? Thanks for any help.