Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Activate entire row, of selected cell

  1. #1
    Join Date
    24th December 2003
    Posts
    158

    Activate entire row, of selected cell

    The user will be selecting a cell, and then use a hotkey to bring up a userform. I want VBA to activate the entire row of the cell selected by the user.

    I'm able to activate every row of the worksheet, as well as rows based off number inputted into cells, but the row of the selected cell is beyond me. Any advice?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th May 2004
    Location
    London
    Posts
    447

    Re: Activate entire row, of selected cell

    VB:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
        Rows(Target.Row).Select 
    End Sub 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    22nd January 2004
    Location
    Colorado Springs
    Posts
    3,992

    Re: Activate entire row, of selected cell

    Or
    VB:
    activecell.entirerow.select 
    
    
    Regards,
    Barry
    Last edited by Jack in the UK; November 19th, 2004 at 05:00. Reason: Code tags

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,716

    Re: Activate entire row, of selected cell

    Hi Et3rnal

    The code below will do this;
    VB:
    Private Sub UserForm_Initialize() 
        ActiveCell.EntireRow.Select 
    End Sub 
    
    

  5. #5
    Join Date
    24th December 2003
    Posts
    158

    Re: Activate entire row, of selected cell [solved]

    Works great, thanks guys

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 3 users browsing this thread. (0 members and 3 guests)

Possible Answers

  1. Enable Button If Entire Row Selected
    By bjwade62 in forum EXCEL HELP
    Replies: 12
    Last Post: December 1st, 2006, 11:30
  2. Determine If Entire Column Is Selected
    By X10A in forum EXCEL HELP
    Replies: 4
    Last Post: October 10th, 2006, 01:01
  3. TextBox, entire text to be selected
    By Sahak in forum EXCEL HELP
    Replies: 4
    Last Post: August 13th, 2005, 23:52
  4. Activate a newly selected (switched) sheet
    By Funchip in forum EXCEL HELP
    Replies: 2
    Last Post: June 10th, 2005, 00:48
  5. if entire row is selected then???
    By adam@luton in forum EXCEL HELP
    Replies: 7
    Last Post: September 30th, 2004, 19:00

Bookmarks

Posting Permissions

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