Search results

Just figured it out I wrote first line as Private Sub Test () Now changed it to following and it worked. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Many thanks though for your support

Thank you Logit a lot for your prompt response. Actually I am not a VBA person so would appreciate if you could elaborate a bit about what is "MyMacro". It didnt work for me somehow. Cheers

Dear VBA Gurus Years ago I saw a post on this forum wherein if you click within a particular range of cells, the value in the selected cell is produced in a destination cell. For that I used following code: >>> use code - tags <<< Private Sub Macro1() If Not...

Thank you so very much Narayank991.. That's exactly what i was looking for. Salute to all of you (dan_I, Hui and Narayan :)

Thank you very much dan_I and Hui. I was away from office so couldnt respond you earlier, apologies for that.. I have uploaded file at https://www.dropbox.com/s/1kmh07gh5rmoqub/Sales%20Chart.xlsx Appreciate your usual support :)

Thanks dan_I but sorry I am missing something here. Perhaps I couldnt pick what you said as I am a normal excel user or I couldnt explain it clearly:). Apologies for that. Actually I could not understand how a slicer will change color of some of the bars amongst many other... All bars are...

Excel 2010..

Dear Excel Gurus!! I need help relating to bar charts color. The situation is as follows: I have a daily sales bar chart for 6 months. On x-axis are days - Jan 1 to 31, Feb 1-28, Mar 1-31 and so on for six months. Y-axis represents sales data. Now All I need is to click/select/highlight...

Hi everyone! I am looking for some excel stuff that could help my kids practicing basic mathemarics. My kid is in grade 5 and would need practice for multiplication, additions, substraction, division, mental maths etc. Can someone help me knowing if there's something available like that?

Thank you Prasaddn. Can you please help me know how to post sample files here. Regards Waseem

Morning all! I need to draw "growth indicators" in excel charts but somehow I couldnt figure out how to do it. Just to clarify my problem, currently I am using "think-cell" application to create charts in powerpoint that are linked with excel. These charts are convenient but do not give much...

Thanks a lot Hui. I guess i didnt described the requirement adequately. I can send you my excel sheet for better understanding. Can you please share your email with me? Appreciate your usual support

Hi everyone. can I arrange all items on x-axis in a chart in ascending order based on values on y-axis? Actually i have a data matrix having various columns of data categories for respective variable in rows. Therefore i cannot sort a particular column in my data series. Instead I want excel...

Thanks a million Hui. You are always there to help. Only a couple more issues. The background color that I need is laightest grey shade and the line thickness also needs to be minimum. Would I be able to save this macro be usable in all excel workbooks or just in one file? Should i save the...

While doing my routine work on excel, my fav formatting style is that first i fill entire sheet with lightest grey shade, then I draw borders of cells in 3D style. For example for upper and left border I select dark grey color and white for lower and right border. Thats how I get an ENGRAVED 3D...

Hi every one. I need to know if it is possible somehow that we could insert comments in a graph which are not visible unless we point a particular bar with the cursor. The concept is same like inserting comments in excel cells. I do need it to describe events underlying fluctuating bars of a...

Thanx Hui. Actually I am looking for some sliders, option buttons etc. But yes I can use some shapes to create some innovative buttons. Thanks again

I am a non-IT person (cannot work on VBA etc.) and using excel for quite some time. I regularly use Form Controls and by now I am really tired looking at these old fashioned controls. Can someone please help me knowing how can I get more beautiful and sort of stylish form controls? I would love...