Sorry, I'm not really following what you're asking here...
Hi,
my case is to create a tab in excel sheet.
eg: there are column1,column2,column3, I want to create a tab which when i click should highlight only the values in column 1,similar another tab should highlight only values in column 2
Please someone help me out on this.
thanks,
Sorry, I'm not really following what you're asking here...
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Also can u please can provide me the detaisl on how to animate an object in excel. like movign forth horizontaly and vertically
Please help me out.
thx,
Let's start with the first question first, and come back to the second one.
So those areas you want to highlight... are they some kind of textbox or shape? Or are you trying to select specific ranges of cells? (Like selecting A1:A10 for example)
What colour do you want them to be? And what version of Excel are you using?
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Ken,
Its a specific range of cells.I want them to be in any colour.My version of excel is 2003.
thx
Okay, so what you want to do is this.
Follow the link in my signature on where to put VBA code. Here's the code you want to start with:
For each button you want, copy the above in, and make sure you update the first line to 2, 3, etc..Code:Sub ColourRange1() Range("C11:C18").Interior.ColorIndex = 6 End Sub
The code, as is, will colour in yellow (I think... been a long time since I used 2003).
Next you need to right click your button, assing macro, and pick the appropriate one.
Hopefully that will get you started, but let me know if you run into any issues.
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
thx Ken,I will try and let u know incase of any questions!!!
Its working Ken,Thx
Can I animate the cells,like when I click the button 1 it should highlight only button one.
Bookmarks