active cell

2003 / w7. I have a series of textbox(s) in which the user enters data. I'm using the data that the user enters to control whether I advance to the next textbox in the series using SetFocus. It works great but...... the cursor is not (setfocus vertical line flash) is not easy to see, I'd...

Hello Excel friends, I have a small project I am working on and need an addition to my macro that will sort 3 columns H:J by the last active cell in Column H. I recorded a macro of me manually doing the sort but this time around the data was only 21 lines long, on occasion it may be more or...

Hi All, I wrote a bit of code that's been working great until now. :( The Records have reached over 1100 entries and my code doesn't do what I designed it for anymore. I just need the segment of code to locate a record number in column "A" and make that the active cell. The offending code...

Hi All, I'm missing something from the code below and its driving me bonkers. What I want is to set the active cell to equal my named range ("MyNumber"). What I'm getting is that it is locating 2 rows above what I want. I want to be able to locate the data row which matches range "MyNumber"...

I need to know how to do the following; When someone clicks on a specific cell, I want a different cell to then fill with data from another worksheet, can this be done? For example, I have cells on a speadsheet box 1, box 2 and box 3. What I want, is when someone clicks on say box 2 to...

I have a Macro 'Timenow' to give current time in a Cell of MS Excel, but then it changes all Cell values of sheet where the macro was used. Sub Timenow() ' ' Timenow Macro ' Keyboard Shortcut: Ctrl+b ActiveCell.FormulaR1C1 = "=NOW()" Selection.NumberFormat = "h:mm" Range("F5").Select End Sub...

This is this code below I want to make it like if userclick Cell / which has hyperlink i Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) If Target.Range.Address = "$D$8" Then 'MsgBox "You can run some code if this hyperlink in " & Target.Address & " is clicked"...

I use the code given as reply in thread: http://www.mrexcel.com/forum/showthread.php?t=353649&page=2 When I change specific range with ActiveCell I've got error: Method 'Intersect' of object '_Global' failed. Any help?

Hello! I have been trying to get the below code to run after I have entered a date in column B and exit the Cell. The code works perfectly if I go out of the cell in column B and then go back into it. After reentering B the code runs flawlessly. I have searched relentlessly for a solution with...

Hello, I have a Spreadsheet where: Column B = Project Number Column C = Project Title Column D = Workstage Column E = Workstage Description I have code that will sort what can appear in workstage(D) depending on whats selected in Column A. this is done using the active cell at the time...

Using Excel 2007 - this needs to also work in Excel 2003 I need to create a Macro for the following Copy Row 1 thru 4 of the column for the Active.Cell to Row 1 thru 4 of the column to the right of the Active.Cell (the active cell will be wherever the user left the cursor in the column used)...

Here is my problem. I'm in Sheet1 and I have a cell selected. I click on Sheet2 and I want to use the value of the last selected cell in Sheet1. How can I go about doing this. ActiveCell brings up the current active cell in Sheet2. I'm using Office 2007 with Visual Studio 2008. Thanks for...

Hi Everyone, I have a macro that mimics pressing F2 & Enter to reformat the cells. Sub F2_Enter() Dim NUM As Integer Dim c As Range On Error Resume Next NUM = Application.InputBox(Prompt:="Repeat how many times?", Title:="Choose", Default:=Selection.Count, Type:=1)...

In chapter 7 of John Walkenbach's 'Excel Charts' book from 2003, he has a section on creating a dynamic chart where the series plotted depends on the location of the Active Cell in the worksheet. In the new edition of this book, 'Excel 2007 Charts', his Table of Contents is very similar, but...

I want to move my userform automatically if it covers the active cell. So far I have managed to use the .top property to have a first attempt. The problem with this is that .top returns a value relative to the "container" of the object. I.e. the userform is contained by the application (I...

Goal: Workbook A obtains link_location argument from Workbook B for use in hyperlink function in Workbook A, where link_location is based on active cell reference in Workbook B. Problem: the user-defined function used to generate Workbook B active cell reference changes when Workbook A is...

Okay, Say I have 4 coloumns of parts and 100's of rows for those coloumns. Than i have 3 seperate coloumns that i have coded that when clocked a check mark appears: If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("F8:F16")) Is Nothing Then...