Search results

thank you sirjb7 but can you suggest some books or reference material I can through to develop my skills and techniques on VBA coding.

hi sirjb7, thank you sirjb7 for your explanation . I think it will take some time for me to understand . let me slowly try to understand it. but I would like to write code like you as well. but let's see how it goes...... :)

hi sirjb7, if you could provide me the explanation then I can also learn how to write complex codes. :)

Thank you so much both of us. Both the codes are working fine. But sirjb7 codes are little bit difficult to understand it. Anyway thank you so much for helping me.

Hi SirJB7, http://www.mediafire.com/?dqbxs09xt7p5igh In my sample file attached in the below link, the range of cell need to be set is "C3:M6". Meaning when ever they are changing on this range based on the product, the current date and time need to entered in column B. For example if i...

Hi All, I need an help one excel formula ,i have specific range with prices, but when ever there is a change in value in the range then one particular need to be updated with now() formula. Find below the snap shot of desired data.... Product Changes happened Jan'13 Feb'13 Mar'13 Apr'13...

Thanks for your reply. But if include the character can i able to get it as fully colored one like we are getting it in CF. Another question can we able to create conditional formatting like one condition for color and one condition for the shape is it possible in excel 2007?

Its for excel 2007 , but there is no icon set available in CF for right and left arrow symbol. Can you please help me how i can get that. Can i able icon like this "<->" in conditional formatting.

Hi, Actually i am looking for an conditional formatting with icon set of "Left and Right arrow" with the colored one like amber. I know that i can get this using windings font but i dont know how to color those arrows. Can you please anyone help me on this. Thanks in advance.

Thanks Kaushik, Your example and explanation are pretty much clear but i need to think little bit to implement in my original. let me try it.

Hi Kaushik, If suppose i too have my comments based on my month then in that case how i can pick up the correct comment , hope you can understand by look at my sample file. http://rapidshare.com/files/3453926849/Sample%20Graph_2.xlsm

hi Kaushik, thanks once again for your time. that's all i wanted . i appreciate all your efforts. My final question why we need to move the graph into another sheet why can't we keep it in sheet 1 itself and try this code. any specific reason behind it...?

Hi Kaushik, Thanks for the reply but your code not showing the comment instead of it saving it in sheet2. I think i did not clearly tell my requirement . please have a look at in the sample file i have provided. In my sample my comments are in row no 14 in this case for picking the comment...

Thanks Kaushik its really helpful but now i am again with tricky question for me, instead of vlookup can we use Hlookup or offset formula , because suppose if i have like below; Students A B C D E F G marks 35 40 55 50 68 75 85 cooments poor - study well poor need to improve need to improve...

Hi All, Can you please help me on this code only. in the above mentioned the comments are based on the next column but shall i use vlookup function instead of getting at next column. TempStat = Worksheets("Sheet1").Range("C" & (Arg2 + 1)).Value This code need to be changed with vlookup...

Hi SirJB7, You guys deserved for these words its my pleasure to told this to you. I have some questions for trying to understand better; 1. Why we need to move the graph into separate sheet and include this code. Its not possible to work these codes in sheet1 itself?

Hi Guys, Hope you all busy in weekends i have got the answer for que.2 in my previous post. now i need to know only question 1 why we need to move the chart into separate sheet can we implement in sheet1 itself.

Hi SirJB7, You guys deserved for these words its my pleasure to told this to you. I have some questions for trying to understand better; 1. Why we need to move the graph into separate sheet and include this code. Its not possible to work these codes in sheet1 itself? 2. Can we implement...

Thank you so much kaushik ans sirjb7, its pleasure to meet you guys in this forum. Thanks a lot....

Hi Kaushik, Thanks for your time in detail explanation. i did everything but when i click the data label it showing the error of object required and it stops in this line of code "TempStat = Sheet1.Range("C" & (Arg2 + 1)).Value". link of the updated file...

hi kaushik, thanks for the response. kindly get the sample file in the link below; http://rapidshare.com/files/1152172019/Sample%20Graph.xlsx 1. text should be displayed inside text box with close option. 2.yes if the user click particular data label then relevant text need to displayed...

hi all, i have a chart in sheet1 and i have series of text and related chart data in sheet2. if any user select any data point in the chart, then based on the value selected the related text need to be displayed from sheet2. how i can do that in excel graphs.