Search results for query: *

Basically, I had a workbook ("main") opened which was supposed to contain all of my macros. I apply my macros on other workbooks. I was doing a test so, few workbooks were open (some already existed others new). I thought I saved my macro in my main workbook but I couldn t find it. I also...

Hi, I was working on a macro in Excel yesterday and I lost the macro. I know that I saved my macro but I had few excel files open and I did not save some of them. I think that what happened is that I might have closed(without saving) the excel file containing my macro without noticing it. Is...

Thanks guys for you answers. While I was waiting for your answers, I thought about PivotTables which I worked with but I have both month and year as rows. It would be nice if I could group it as Skip mentionned. Skip I am trying to figure out how you do your counts of datefield and grouping...

Hi , I have a list of dates : e.g. 31/12/2003 31/12/2004 01/04/2006 24/04/2006 11/05/2008 21/05/2008 I need to count the occurence of each date (just for months/year) the result should give me: Project date Results 1 12/2003 1 2 12/2004 1 3...

Hi, we built a hierarchical flexgrid following a step by step book that showed us how to connect that mshflexgrid through data environment which works. For now, the felxgrid shows all options of a products but we need to show the options of a specific product only when that product is selected...

We finally made it work! Thanks so much for your help guys! we did two things: we added .source=strfund in the with statements and in the whereclause of each if statement the right name was fund_optionID instead of fund_options (which is the table) here is the final code thanks again! Private...

how would you do that andy? like chkequity.display? where would I put this in the code?

Hi Thanks again for helping us Golom. We tried your code as it is and that s the error it gives us (it points to the .open strfunds) run time error -2147217904(8004Oe10) no value given for one or more required parameters would you know what it means?

Hi, Thank you for answering us, the only thing is that we are not working with DAO it s with ADO connection. We thought that it might be easier to show what we have done so far. The code does not give the results we want. We would like to display the results(two fields) on the flexgrid depending...

Hi, I have 3 check boxes of products (A B C)and a flexgrid besides it. I have a table in access containing information of those three products. (e.g. PRodID: A11 A34 B45 B45 C3 C4) where the first letter shows which product it is linked to. When I click on one check box, I need to select only...

we solved the problem at the end but thanks guys

HI How do you set the column width in the hierarchical flexgrid with custom column headers?

Hi, we built a product form that is linked to access(2000)using ADO. WE created a combo box that shows the list of products. (this part works) Every time we choose a product on the combo box, the description of that particular product should appear on a text box. (this part doesn t work). We...

Thank you for answering so fast Zathras. I tried what you told me but it only works if I input 1,2 or 3 as numbers in my cell if I have let say 4,67,89 respectively, the formatting does not work. Is it because of the first number in the parenthesis ? (RANK(1,$A1:$C1)=A1)

Hi, I think I have seen a post on this topic before but I was not able to find it and I need to do it very quickly, if someone could help me please. I have three columns containing numbers. I want to do a conditional formating for each row (3 cells) to show the greater number in red, the middle...

You re right Glenn , what I meant was I would have to go through many cells. Thanks for the loop, I made slight changes and it did work!

oh I forgot to add, the column does not change but the row does. e.g. next cell will be AY92 not AX93 thanks in advance!

Thanks Chris for the link it s quite useful. But I decided to build the macro, show it to my colleague and see what he thinks. Now my question pertains the VBA. Basically I started from here and it works but only for a specific cell. Range("AX92").GoalSeek goal:=0, changingcell:=Range("AU92")...

then is there another way to do the same thing than goal seek using another function that can be invoked from the formula bar?

so you are telling me that the only way to automate the goal seek method is to use a macro right?