Results 1 to 9 of 9

Thread: Tabs in excel

  1. #1

    Tabs in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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,

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    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.

  3. #3
    Ken,

    I want to create a button in excel sheet that links/highlights only a particular row when i click on the button.


    Here in this case when i click button P1 it shoudl highlight only P1 and similarly for P2 & P3
    Click image for larger version. 

Name:	2012-12-21 12-32-34_Microsoft Excel - Book1.gif 
Views:	26 
Size:	10.4 KB 
ID:	983
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	untitled.GIF 
Views:	18 
Size:	15.2 KB 
ID:	982  

  4. #4
    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,

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    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.

  6. #6
    Ken,

    Its a specific range of cells.I want them to be in any colour.My version of excel is 2003.

    thx

  7. #7
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    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:
    Code:
    Sub ColourRange1()
        
        Range("C11:C18").Interior.ColorIndex = 6
    End Sub
    For each button you want, copy the above in, and make sure you update the first line to 2, 3, etc..

    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.

  8. #8
    thx Ken,I will try and let u know incase of any questions!!!

  9. #9
    Its working Ken,Thx

    Can I animate the cells,like when I click the button 1 it should highlight only button one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •