Select / Highlight Every Other Row

Sep 4, 2008

I have done a search both on here and on the Internet in general, and I can't seem to get this question exactly answered...

How does one select/highlight every other row?


(Other than Hold CTRL and select every other one)

Related issue:

How would you go about INSERTING alternating rows?
Starting with rows
How would one make it into




View 9 Replies


Highlight/Select TextBox Content

Nov 12, 2005

i am working on a userform that contains several controls one of which is a textbox ,everything is fine except that i need to know which textbox property to use in order to highlight the text writen inside the textbox, i know "setfocus" but thats not excatly what i need, i need to highlight the text inside the textbox.


"textbox.setfocus" sets the focus onto the textbox without highlighting its content
what i need is:

"textbox.ur suggestion" sets the focus onto the textbox & highlight its content, this way i will no longer have to clear the text using the backspace key to write another text

View 4 Replies View Related

Select From Listbox & Highlight Corresponding Row In Worksheet

Dec 29, 2007

I have a userform that does search using Name. If there are multiple records found it displays a message "There are X instances of (value in name)" and shows a list box. When user selects Find All, the multicolumn listbox gets populated. Selecting a row in lisbox populates the corresponding values in the userform. Problem is that selecting a row in listbox fails to select the corresponding row in the worksheet. As a result, if i change the values in the textbox (say for eg. Phone) the changes are updated in the row selected on the worksheet but not on the required row! Pardon my innocense, I am very new to VBA. find the attached worksheet. This is not my work, I found it during research. Auto Merged Post;Sorry the previous file had error. find the updated worksheet.

View 4 Replies View Related

Highlight (or Select) Cells From Row 1 Through A Numeric Var X In Column A

Jul 2, 2014

How do I select or highlight cells from row 1 through row x (a numeric variable) in column A? I'm eventually hoping to shift those cells in column A (from row 1 to x) to the right by one.

View 1 Replies View Related

Select/Highlight Item X Of Listbox On Worksheet

Jun 4, 2008

I have a ListBox that comes from the Control ToolBox

I know how how fix

ListBox1.ListIndex = 0

my problem comes because when i run a Macro... I lost the focus of my listbox, I mean once I move around the workbook through vba the listbox does not show anymore... one item of the listbox selected, I mean in blue.

Is there a way to do kind of:

activesheet.ListBox1.Selected(5) = True

I I want to see the fifth item of my Conbo Box on blue, I mean selected

View 9 Replies View Related

Excel 2010 :: Highlight Column And Row While Select Cell?

Aug 10, 2012

Highlighed the Column and Row of the selected Cell. I have seen someone using it. Whenever he click on any cell the related column and Rows clour change. For Example if I select Cell B5. The Column B and Row 5 change its colur from B1 to B5 and Row from Column A to Column B. If this option is already available in office 2010

Column B

Row 5

View 3 Replies View Related

Highlight/select Data Between 2 Cells Containing Specific Words

Nov 6, 2008

Sample data (all in column a):

Heading 1
Heading 2
Heading 3
Heading 1
Heading 2.........

View 9 Replies View Related

Vbcodes To Select Start Date Then Begins Highlight Until End Date

Oct 28, 2006

i need VB to select the start date of booking and autohighlights the "blank booking slot cells" until the end date that is input in Excel. You can visualise this as a room booking system. The left most column is the dates and the first row represents the different rooms type. E.g. if one guest books the Twin Deluxe No. 123 room on 23 Oct 2006 until 25 Oct 2006. We wish the VB can essentially help us identify the start date then begins highlighting the three slots for 23, 24 and 25 Oct on the column for the Twin Deluxe Room 123.

View 4 Replies View Related

Highlight-Select Start Date To End Date

Oct 28, 2006

We are doing a project on a booking system and wish to use VB codes to autohighlight the slots from the start date until the end date.

View 9 Replies View Related

Select From Multi-Select Listbox And Get Index Number?

Oct 30, 2012

I have a multiselect listbox with values that gets populated from a sql statement, and I would like to get is the first or second index from the selected item. I know how to get the listindex from a combobox by using:

cbnumber.List(.ListIndex, 0)

How can I loop through and get the 1st index number for the selected items only from the listbox? I want to pass this index number to another sql statement.

View 5 Replies View Related

Range Select Statement To Select A Cell

Jul 7, 2008

I want to put a range select statement to select a cell and count down 10 cells and copy.

View 9 Replies View Related

If Select Sheet, Select Range Statement

Oct 4, 2007

I have a command button on sheet MASTER. When the workbook is Activated I want it to check and see if in sheet COSTM, cell B3 there are the words "Project Number", if so then show command button (ClearPrevious), if not, don't show. Also, when the If statement is finished, then the workbook needs to end up showing the sheet MASTER. I have tried various codes and none work, or they are on perpetual loops. I know this has got to be simple, but cannot find an example to take from to solve the issue. Would appreciate any help offered. Below is code I have right now.

Private Sub Worksheet_Activate()
If Sheets("COSTM").Select Range("B3").Select = "Project Name:" Then
Me.ClearPrevious.Visible = True
Me.ClearPrevious.Visible = False
End If
End Sub

View 9 Replies View Related

Macro (Select, Sort And Select)

Nov 16, 2006

I need to get a macro to select all the data in column "A", sort it in ascending order, omit the blanks if any, then select (highlight) all the data so that another macro can be run.

When I record it, it will only record up to the last row I highlight but the data always changes so there could be more or less.

View 9 Replies View Related

Select Specific Cell Then Select The Row

Aug 13, 2007

I have column A with various values in cells.

For instance, DG, GS, HG etc

I wanna do if a cell in column A is equal to DG then select the entire row that contains the cell. then call other sub.

View 9 Replies View Related

'Select Method' Failure 'error 1004 Select Method Of Range Class Failed'

Oct 28, 2008

My workbook holds a month template and sheets for each month. I work on modifications in the template ,but would then like to update all the monthly worksheets. I recorded a macro to show me how to start programming the vb sub, but get a runtime failure 'error 1004 Select method of range class failed' when trying to select the column to copy,

View 4 Replies View Related Error (SELECT METHOD OR RANGE CLASS FAILED)

Jul 23, 2008

I have this:

Private Sub CommandButton1_Click()
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
End Sub

View 9 Replies View Related

Highlight The Row

Jun 25, 2009

I'm using the code below to color every row where "MAIN" and string
starting by "FFR0" coexist, but it doesn't work

View 6 Replies View Related

Highlight A Row

Aug 7, 2007

In a workbook. I have a cell with a hyperlink to different sheet in the same workbook.

I want to make it so, that when someone clicks on the hyperlink and is taken to the cell on the sheet i linked to, that the whole row of data highlights.

The highlight can only be turned on when someone clicks the hyperlink.

Does this require VBA script?

I am using Excel 2003.

View 9 Replies View Related

Highlight The Row ...

Nov 13, 2007

I have a spredsheet with names going down column A and then a lot of data in the next 20 columns. It is sometime a challenge to see for which name the data is associated with becuase I have to look across a long row...

Is there a way in Excel, that when you click on a cell, it would HIGHLITE the row that you are in at that moment?

View 9 Replies View Related

Highlight Every 5th Row

Dec 5, 2008

Is there a script to add a boarder or highlight every 5th row in excel?

View 15 Replies View Related

Highlight Every Other Row

Jan 24, 2007

I need a code that will highlight every other row in a some color.

I would like the macro to start in row 7 and use column A as a reference to know when to stop (last populated row in column A is where it needs to stop).

The rows that get highlighted can all get highlighted in the same color, and the entire row can be highlighted.

The twist to this is that there are hidden rows in the range and I want the macro to disregard those.

View 6 Replies View Related

Highlight The After Due Dates

May 29, 2014

I am working on closeouts and I would like the late due dates to be highlighted in three ways: past 30 days, past 60 days, and past 90 days. Also, I would like the highlighted to be disappear when the form is sent..

View 3 Replies View Related

Highlight The Cell

Mar 25, 2009

i have got a spredsheet, with clients names on it and in cell Q i have the clients account number, when iam looking at the clients name i also want to see the number, is there any way to highlight the cell i am on.

What i mean isusing the arrows keys i want to make the row highlighted, is there a way to do this

View 2 Replies View Related

Extend Highlight Bar

Sep 22, 2009

I am editing a fairly sizeable name, address list and I would like the row highlight bar to extend across the page. For instance, when I click on the row number the highlight bar extends across the row, but when I hit return the highlight disappears and I have to click row by row. I would like the highlight bar to extend across a row and then move up or down with the arrow keys.

View 5 Replies View Related

VBA To Highlight Inserted Row?

Jul 7, 2014

Below is some code I am trying to complete but ot does not ALL work.

I am inserting a row and I want the row to be highlighted.

The insert part is working ok but not the highlight part.


View 2 Replies View Related

Highlight Change In Row

Feb 25, 2009

Excel 2003 > In a given row, I need to change the fill-color of the cell in column C if the user changes any value in columns D through Z. How to? Need a VBA code snippet.

View 2 Replies View Related

Highlight Birthdays

Jan 3, 2006

Using conditional formatting how would I highlight birthdays coming up
within the next 14 days.

I can't use < today()+14 since birth year is in the past.

View 9 Replies View Related

0 To Highlight Red With Con.format

May 29, 2008

I need a cell to highlight RED (via conditional formating) if the cell reads 0.

When using conditional formatting and entering, the cell is equal to 0, it turns all the cells red that are empty aswell. This is what i dont what.

The only cell i require to turn RED is that with a 0 (zero) in

View 10 Replies View Related

Highlight Only Percentages

Mar 14, 2012

I would like a way to use conditional formatting to highlight percentages that are over 50%. The problem is that I have other numbers in the same column that are not percentages but I would like to ignore them for highlighting purposes? Can this be done without sorting the columns?


345- ignore
Ken- ignore
2500- ignore
45.6%- do not highlight
65- ignore
92%- highlight

View 5 Replies View Related

Highlight Row If Criteria Is Met?

Apr 18, 2012

I have a value in cell B23. I C23 & C23 is blank and numbers 0 to 18 is in cells E23 to U23I. I need VBA code that hightlights the row up to the value as indicated in B23. For example: B34 contains 4, the code should highlight the two blank cells up to cell J23.

View 7 Replies View Related

Copyrights 2005-15, All rights reserved