Free Microsoft Excel 2013 Quick Reference

Detect Mouse Click in Cell

Hi

I wrote a routine in VBA for Excel a couple of years ago and then promptly forgot how I did it. I no longer work where I did so have lost the code also...

Does anyone know how to detect a which cell has been clicked in/on in Excel so that I can programme the sheet to put a tick in the cell automatically. I have got the little boxes that come with the drawing package but frankly that's very inelegant so I want to do it properly.

I do remember that I placed the code onto the code section for the worksheet it was on...

thanks in advance

Paul


Post your answer or comment

comments powered by Disqus
Hello,

Its possible to do a mouse click in one or several excel cells and that cells turn on the background color into gray,(and if the cell was already clicked and if clicked again the background color desapears and the value will not be added to the sum [just like a press button]) and put the sum result in another cell?

Another thing that i wanted to do, if a value (number) of a cell is negative can that same cell value became bold and red for example?

Many thanks.

I know of

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

but I would like to expand this idea to detect any change in cell selection across all open workbooks.

Thanks!

Nick

I have lost my ability to use the right mouse click in Excel, works
everywhere else. Any ideas on how to get it back??

Thanks in advance

I have a tablet PC with Vista Biz and Office 2007 installed. I noticed that
the mouse right click function does not appear in the working cell. Anyone
know how to enable right mouse click? The mouse is definitely working as the
right click function works outside the cell (within excel 2007).

Thanks

Is there a way of counting mouse clicks on an active XL cell and displaying the real time count in the cell, in essence giving a click count?
Or in the case of a handheld, tapping an active cell and having the value incrementally increase with each tap...

Whether I open a new Excel (2003) spreadsheet or existing one, once I click
on any cell the mouse is stuck in multi-cell selection mode. Moving the
mouse highlights all cells from the first cell selected to where ever the
mouse is moved. Can't click on any menu or icon, can't exit excel. How did
I get into this mode & how do I get out? Thanks.

Whether I open a new Excel (2003) spreadsheet or existing one, once I click
on any cell the mouse is stuck in multi-cell selection mode. Moving the
mouse highlights all cells from the first cell selected to where ever the
mouse is moved. Can't click on any menu or icon, can't exit excel. How did
I get into this mode & how do I get out? Thanks.

I'm using Microsoft Office Excel 2003 on a Windows XP laptop. I've been able to successfully use it for many months now but am currently experiencing a problem.

Whenever I try to click (left click) on a cell, the program basically acts as if I'm clicking and holding so when I move my mouse around, it begins to select multiple cells. Even when I move away from the cells and to the top menu the icon stays as the plus sign that is typical when hovering over cells and I'm unable to access any of the menu items (such as File, Edit, etc.). Eventually to get out of it, I need to push control alt delete and force quit the program. Once I've clicked on a cell, there is "no return". It just keeps selecting multiple cells. I've tried double clicking, right clicking etc. to no avail.

Any ideas?

I'm using a laptop and I've tried using the mousepad AND an attached mouse.

Thanks in advance.

Working in ExCel on new Macintosh iMac G5 computer, I suddenly lose
capability to make
cell active by clicking mouse on a cell. I can use arrow keys to move
cell to cell to enter data
but cannot make cell active for entry by moving mouse to it and
clicking. Need solution.

Is there a fuction/something I can do where I can get the user to click in the cell to change the value? Like if the user left clicks in the cell it goes up to 1, and if the user right clicks on the cell its takes 1 off the current value?

It will soon be obvious, but I am not a VBA expert. My problem:

I am trying to make it so that when you double-click in a cell in column A, a message box opens populated with the text string in the corresponding cell (same row) in column Z. Seems to me like it should be easy enough, but despite spending the last hour searching for clues, I can't seem to figure it out.

Thanks in advance.

Is it possible to click in a cell in Excel to run a macro? assign macro to
cell type thing.

thanks

Hello.

I'm using Excel 2003.

I have the following formula in cell B6: =VLOOKUP(A6,CUST_ID,2,FALSE). My problem is that the formula returns #N/A unless I ckick in/out of the cell holding the lookup_value (A6). If I do that (click in cell A6 then press enter without making any change) the correct result is returned in B6.

Any suggestions for how to get the results without having to click in/out of every lookup_value cell? (I have 19,000 records so that's not gonna happen.)

THANKS in advance!

Hi,

When you click in a cell with a formula, Excel will then put colors
around the cells that are referenced.

Somehow I turned that feature off. Now I do not get colors in the
other cells. Where is that option to turn it back on???? I've looked
and looked but I just can't find that option.

Thanks for the help.

--
albean
------------------------------------------------------------------------
albean's Profile: http://www.excelforum.com/member.php...o&userid=28751
View this thread: http://www.excelforum.com/showthread...hreadid=484362

When I open excel the right mouse click menu is constantly there, does anyone
know how I can remove it? How did it get there in the first place?

Hope someone can help
Rgds
irish RN

Hi,

When you click in a cell with a formula, Excel will then put colors around the cells that are referenced.

Somehow I turned that feature off. Now I do not get colors in the other cells. Where is that option to turn it back on???? I've looked and looked but I just can't find that option.

Thanks for the help.

I require to double click in a cell with VBA code. The excel help explain
the following: Worksheets("Sheet1").Activate
Application.DoubleClick
This however do not work.

Can someone help?

I want to write code for picking a default folder where the data file to be imported is stored. This default path is stored in, say, Cell B1. Another similar path for another data file is stored in, say, cell B3. I have written the code for displaying a browse window for picking up the folder as under -

Sub OpenFolder()
Dim fPath As String

    With Application.FileDialog(msoFileDialogFolderPicker)
        .AllowMultiSelect = False
        .Show
        If .SelectedItems.Count > 0 Then
           fPath = .SelectedItems(1) & ""
        Else
           End
        End If
    End With
    
End Sub
Now the help I need is to suggest a code so that when a user mouse clicks on cell B1, the above code is executed and the returned value is stored in Cell B1 and when he clicks on cell B3, the above code is executed and the returned value be stored in cell B3.

It will still be better if the mouse click and an 'Enter' key both can be identified to execute the above code.

I set up a column with 527 rows as a date formatting but the formatting doesn't work until I click in the actual cell, then click in the formula bar up top and then hit the checkmark to the left of it. Then the formatting works, but I don't want to have to do that with every cell. Is there a way around that? I tried F9 and that doesn't help either.

Hi to all,

I have a form in which there is a field which has a few hundred specs for conducting inspections. They run in a sequence of values from "M1XXX rev. X" to "M4XXX rev. X" in cell N10. I'm trying to hide lines 513 to 538 whenever "M3XXX rev.X" to "M4XXX rev. X". I already have part of the form that is already hiding some of the rows and columns but i'm absolutely cluless on how to write the codes to detect just M3 and M4 in the value that appears in cell N10 to hide the lines. Can anyone help?

Here is the form:
testing_form.xlsm

Thanks.

Regards,
Ayub

I would like to be able to track progress of various tasks/occurences by allowing users of a spreadsheet to just click in the appropriate column and in doing so, it would fill in the current time and date. I.E. Column headings would read, "Item Sent to Review", "Item Received From Review", "Item Sent to Specialist", etc. and I want users to be able to double click in a given column to populate with current date/time information, how can this be done?

BACKGROUND:

I have a file called summary.xls and 80 data files called data1.xls,
data2.xls, etc. Let's say that in the summary.xls file, cells A1-A80 contain
the text "data1.xls", "data2.xls", etc.

I'd like cells B1-B80 of summary.xls to equal cell C50 on Sheet1 of
data1.xls, cell C50 on Sheet1 of data2.xls, etc. One way to do this is to
type "=" into A2 of summary.xls and then open the file data1.xls and click in
cell C50 of Sheet1. Then repeat this process for all 80 files. Obviously,
that's a lot of work.

MY QUESTION:

I'd like to build a formula to put in cells B1-B80 that will pull the
filename from column A and create a formula like:

= '[data1.xls]Sheet1'!$C$50

To do this, I tried just putting the cell location in place of the
"data1.xls" in the example above so it looked like:

= '[A1]Sheet1'!$C$50

But the result was Excel trying to open a file called "A1". I also tried
converting the "A1" string above by putting:

= [T(A1)]Sheet1'!$C$50

But then Excel just tried to open a file called "T(A1)".

There must be a way to do this. Any ideas?

I want to have 2 lists from the control box. One list has the entire list of items and then I want to be able to double click an item from that list so that item populates in the second list, I then want to be able to double click an item on the second list to delete the item. Is there a way I can do this. I was looking for mouse clicks in vba, but couldn't find any.

BACKGROUND:

I have a file called summary.xls and 80 data files called data1.xls,
data2.xls, etc. Let's say that in the summary.xls file, cells A1-A80 contain
the text "data1.xls", "data2.xls", etc.

I'd like cells B1-B80 of summary.xls to equal cell C50 on Sheet1 of
data1.xls, cell C50 on Sheet1 of data2.xls, etc. One way to do this is to
type "=" into A2 of summary.xls and then open the file data1.xls and click in
cell C50 of Sheet1. Then repeat this process for all 80 files. Obviously,
that's a lot of work.

MY QUESTION:

I'd like to build a formula to put in cells B1-B80 that will pull the
filename from column A and create a formula like:

= '[data1.xls]Sheet1'!$C$50

To do this, I tried just putting the cell location in place of the
"data1.xls" in the example above so it looked like:

= '[A1]Sheet1'!$C$50

But the result was Excel trying to open a file called "A1". I also tried
converting the "A1" string above by putting:

= [T(A1)]Sheet1'!$C$50

But then Excel just tried to open a file called "T(A1)".

There must be a way to do this. Any ideas?


No luck finding an answer? You could always try Google.