Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?
View 11 RepliesI am creating a resource and I'd like the users of this resource to be able to click a cell which will then automatically come up with an x or similar symbol (tick?) and then if they click the cell again the x will disappear. Is this possible? I don't want a drop down box where they have to choose what they want, I want it to be an automatic action when the cell is clicked because there will be many cells that I will need to do this.
View 14 Replies View RelatedI have a spreadsheet that users update which I then want them to perform a number of checks on. At the bottom will be a button for them to click stating "Click here to confirm checks completed". When they click it I want it to put a flag somewhere that I can then use to prevent them from saving if they haven't clicked the button. I know how to do the saving but, but how do I get the button to put a flag somewhere?
View 2 Replies View RelatedI wonder if it is possible to make a macro that right clicks a cell and then chooses a option from the list?
View 11 Replies View RelatedI have big library books database file. now i want to re check all the book with physical stock and mark in excel file.
i have one more file with books barcode no.
now i want to mark multiple cell in sheet..
I have the following formula and need to incorporate that it is only a "B" if B20 also matches in named range "Breakdown_RSC"
Formula: ...........
I need the following section to take into account the data in B20 as in if it matches the data in the cell it should be a "B" in the cell.
I inserted a check mark and tried to us a vertical lookup and post the check mark
All I get is a horseshoe looking character. When I do reference to the cell I get the same symbol. What I trying to do is to place a check mark by the items which have been approved. I know I could do it with an "X" or a color, but top management wants a check symbol. I am using Excel 2007
i'm using excel 2003 and i'm trying to mark 7 cells in a row by conditional design by one of the cell
example : if the date on january? mark all line in yellow, for february mark in red and ect
A B C
528602545 assafsarit@walla.com 01/01/2013
527271005 eti_sh6@walla.com 01/01/2013
[Code] ...........
I need to click on a cell and when I click on it, it should change colour and insert a tick (or other symbol).
View 14 Replies View RelatedI'm trying to make a macro, which search for a cell value of "Year". And from that cell, I want to make a range selection down to the first empty cell in row B or the first cell value with "Contracts of difference".
See the attached document I want to mark row 50 to row 55, and Column A to K. However as this range is in different rows each time, I need to make the selection dynamic. And I belive the heading "Year" is the best reference point.
I'm trying to find a macro that will copy data from the areas of B120:E179 and I120:K179 for example (linked to another worksheet within the workbook) and special paste (Values Only and skipping blank cells) it to the next available open cell up top where basic data entry will be taking place B10:E29 and I10:K29. I need it to only copy/paste the rows with data (skipping all cells/rows with no data) and once it is finished coping I will need it to place an "X" in column M next to the row that it copied data from. I would also need it to reference the data in each row from B to E and if there is an entry say on B14 to E14 that matches it but if I10 to E29 are blank then paste that information on row 14. If it does not match or if those columns are full then paste on next available line.
I hope I'm making sense here. This is for a vehicle tracking log between checkpoints. Each driver and info will be listed on each row. Columns B through E will contain information for each driver: name, badge, #passengers, and vehicle #. The log lists location, time, and destination for outgoing travelers in columns F to H. Incoming info is listed on Columns I to K............
what code I can put behind a button so that once I click on that button,
What ever cell i click on, the whole row of that cell will be colored a certain color.
Is this where i would used a target approach?
I have a sheet where i have many differently named areas (like state1_1 and state1_2) When I doubleclick on a cell then a macro should run with following criteria: 1) Macro will run if the doubleclicked cell is part of any range in the list. Here I mean that names of ranges which belong to that list start with word state (like state1_1 and state1_2). No other ranges should not be in that list. If the cell is not in the range that is part of the list, then nothing should happen.
View 2 Replies View RelatedI am using a worksheet to scan or enter students into a school event and determine their eligibility to participate in the event. Everything is working great but I need to do the following on Enter Student button click:
1) Cut scanned value (ID number) from input Cell A1
2) Paste value into next empty cell in column A (Rows build as students are inputted)
3) Copy Eligibility status (text) from column F into A6
I have a limited VBA/Macro background and have NEVER got a button to work.
My goal would be to click on a cell within a range of cells (in a column) and have the value copied to a specified destination cell. There would be a few different columns with source cells and two destination cells. Each column would to copy to a specific cell. My ojective is basically to deal with different processing times (days, weeks, months).
Here's a little visual, clicking on C4 for example would copy the value "5" to cell B2. Clicking on D4 would copy "12" to A2.
row/col
A
B
C
D
E
1
Days
Weeks
Processing time X (weeks)
Processing time Y (in days)
Processing time Z (in weeks)
2
3
10
110
3
4
11
111
4
5
12
112
5
6
13
113
I have a worksheet dealing with customer order numbers in rows and various information about those orders in columns. The first 10 rows contain generic " header" type information with formulas to return certain values from the data below. Panes are frozen below row 10 so I can manually scroll down to see data. My "line numbers" (1,2,3,etc.) are listed in column "A", and begin on worksheet row 11.
The worksheet is set up so that when I enter a customer order number in cell "F2", my line number (Excel row + 10) is returned in cell "L2". I would like to use a Macro that would give the user the option (possibly with a button) to automatically scroll to the report line number returned in cell "L2".
Any way to make it so that if a user clicks into any single cell in columns O to AH, it will populate the cell with an X?
So if user clicks on cell, populate with X.
Is there a better way to do the following:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("b5").Address Then
Sheet1.Range("j5").Value = Target.Value
End If
If Target.Address = Range("c5").Address Then
Sheet1.Range("j5").Value = Target.Value
[Code] ........
I currently have
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address = "$H$1:$K$1" Then
Call FINALIZED_BY_QC
End If
End Sub
In my sheet code. In a macro I have some code to unlock these cells
Code:
Range("$H$1:$K$1").Select
Selection.Locked = False
But the code is trying to select these cells and run the macro. At this point I just want to simply unlock the cells not select them...
I have been able to record a macro which changes the value of a cell, based on a hyperlink click.
However I am not able to make it work properly for my lack of VBA knowledge.
The issue is I want to click the hyperlink in the column "B", say "B2" which is some email say (abc@gmail.com). This should result in Cell C2 changing its value to "sent".
If I do not click B2 , then value of C2 remains blank.
The macro which I recorded looks like
Code:
Sub Macrotest1()
'
' Macrotest1 Macro
'
'
With Range("B2")
Range("B3").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Range("C2").Select
[Code]...
Sample file is uploaded in this location
Download email addr1.xlsm from Sendspace.com - send big files the easy way
This works till cell B5 since I recorded it till there.
I am not able to write a code for looping the same till the end (say B1000). I don't want to write till B1000 the same piece of code, but would like to do a loop (For, With...end with)...but really don;t know how to go about the same.
how to highlight an entire row and column automatically when the cursor activates a cell in a spreadsheet?
I have a large spreadsheet and when I click on a cell I'd like the whole row to be highlighted so I can check that I'm editing in the correct row. I know that the ROW HEADER is highlighted but I'd like the entire row to be highlighted. I'd like this to be so for every cell on my spreadsheet.
i have macro that opens up a calendar and inserts a date. i'd like it to automatically run when a particular cell is clicked. i don't want it to run for all cells, just cells in a certain column.
View 9 Replies View RelatedHere is a selection of my data:
[data] ......
Now here's what I would like to achieve.
If I click or maybe double-click on a cell I would like the cell colour to change to lets say yellow. However, I would like all matching cells to change colour too.
So from my example above if I clicked on C13 "3 TIMER" then C13 would change to yellow as well as C14 - C17 - C18 - C19
i have this piece of
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address "$A$1" Then macro1
Exit Sub
End Sub
I want so when i click on cell A1 it will run macro1.
So far the click on the cell works, but it works with every single cell I click on. How to I get it to just work with cell A1 instead of everyone single cell I click on?
Also, there are about 30 different cells that will run different macros, how would I go about creating adding the code the one above without having to create separate sub worksheets?
How do I run code if I click on a cell in the workbook, like Cell A1 of Sheet1?
So far I just have...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Stop
End Sub
Is there a way to make a cell that when you click it a calendar pops-up and you can click a date on that calendar to auto-fill in that cell?
View 9 Replies View Related1. I would like to trigger an event once i click on a cell, for example I click one click on a cell (1,1) and it run some macro.
2. When I bring my cursor to this cell, to change cursor pointer to pointer like in hyperlink.
I have a spreadsheet with many worksheets in it. Sheet ' Names' has personal data for a person. Sheet 'Credits' has more information about that person's work.
When a cell in sheet 'Names' is clicked, the user is forwarded to cell containing the same name on sheet 'Credits'. I know how to do that with hyperlinks, but its not going to work becuase the list of names is updated.
1. How do I make the Sheet 'Names' react to clicking of the cell? Do I use procedure 'Worksheet_SelectionChange()'?
2. How do I switch sheets to highlight the cell on sheet 'Credits'?
3. How do I compare values in cells that are on 2 different sheets?
The code to highlight the cell is this, i think:
For x = 3 To <some number>
If Cells(x, 1).Value = <value of cell In sheet 'Names'> Then
Columns(x).EntireColumn.Activate
x=x+1000000
End If
Next x
I know this may seem trivial, but I am very new to VBA.
I want to jump from one cell position (on picture, marked with numbers from 1 - 6)
But i want to jump to them respectly(first to 2, then on 3....) I have used these numbers just to describe space between cells(in rows and columns), and actually those are blank cells! Starting blank cell can be everywhere(e.g. A2), it doesnt matter, it is only important how to jump from one cell to another in mentioned manner!!!!!!!
exist any function that do following?
I am on the row 100 in column G. I had a freeze the first row where i have hypertext and other function. I want add here (in the 1. row) something like hypertext, but i want to stay in the row where i was.
When i am on row 100 in column G and i want to create function which move my cursor to column W but in the same row (row 100 in this case).
Next time i will be in row 154 and i will want to move my cursor again in column W and use this same hypertext/function or what.