Using Double-click On Mouse To Perform An Action?
Aug 18, 2009
I have an excel file with a column (I) which lists the total number of businesses in a different tab (DATA) that meet certain restrictions (these restrictions being listed in the same row in different cells). When the cell under coluimn "I" is double-clicked, it pulls the businesses from tab DATA that meet the restrictions for that row and shows them all in another tab.
I don't know the person that created this and was wondering if there is a way to figure out what is being done to make this happen? I looked in macros, but didn't see anything relating to this. Anyone know how this is done?
So you know, I have tried double-clicking other cells, but nothing happens - not even editing into the cell (altho this can be done from the toolbar up top).
View 4 Replies
ADVERTISEMENT
Apr 12, 2013
If a name is entered in cboRepName combo box, I want to check if the name matches the list of names in the named range "Names" found in sheet repInformation. If the name is not found, then perform tasks.
Here is what I have so far, of course is not working, but I think I am close.
Code:
Private Sub cboRepName_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
Dim repName As String
Dim nRange As Range
[Code].....
View 2 Replies
View Related
Sep 22, 2009
In all the cells in column F I have a validation list with several predefined choices, but at the bottom of this list I want an "Other..." option, which when chosen, enables the user to enter a new string in that cell if none of the predefined did not match.
View 7 Replies
View Related
Mar 10, 2014
Converting old reports to usable excel format. I am having trouble using VBA to set up a looping macro that would search Column A for cells with the text string: "ACTIVITY TOTAL". If cell has that value I would like to perform text to column action on the adjacent cell (R0C1). The macro recording for the test to column settings i need is :
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, OtherChar _
:=":", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, _
1), Array(6, 1), Array(7, 1)), TrailingMinusNumbers:=True
I have attached a sample of what I am currently working with. The actual file has roughly 6000 lines of data, so I would like the macro to go through all lines.
Attached File : LoopingVBA.xlsx
View 3 Replies
View Related
Aug 23, 2013
I am trying to develop a system to allow me select different parts from multiple sheets and then add them into a bill of material on a separate sheet.
[URL] ...........
I have written some VB script the best I can and it includes a 'commandbutton' to make it easy for the user of the workbook to use.
This is how it works:
Go to 'Step 1 - Manifold 8640' tab and highlight one of the yellow cells.Once you have selected a yellow cell, you then click the 'select' button above.The value (along with other values) are copied to the 'Smart Calc' sheet.Then you go to 'Step 2 - Gland Plate' tab, select a yellow cell, click the 'Select' button.Notice how the 'Step 2 - Gland Plate' value is entered into a different group in the 'Smart Calc' sheet - this is great................BUT
The issue I am having is:
If the user goes to 'Step 1 - Manifold 8640' tab, highlights the desired yellow cell then presses the 'Select' button twice, it will add two lines of data in the relevant 'Step 1 - Manifold 8640' section....This is ok.But when the user clicks a third time, the 'Step 1' data will overflow into the 'Step 2' section of the 'Smart Calc' tab...because the script tells the data to look for the next available line to write to. This is what I am trying to avoid!
Instead, i would like a message box to popup to indicate to the user that they cannot add anymore data into into the 'Step 1' or 'Step 2' sections of the 'Smart Calc' tab until they clear the data from within the relevant section in 'Smat Calc'.
I would like to set limits on where each 'Step 1' or 'Step 2' data is written to the 'Smart Calc' sheet (so it is within its relevant section). As you can see the script basically looks for the next available cell but this isn't really good when the data 'overflows'.
Note that you are able to highlight the yellow cells in the 'Smart Calc' tab and press the delete key, it will delete the data to clear the line. That is how i designed it to work so if the user makes a mistake they are able to just delete the relevant line and enter new data.
View 1 Replies
View Related
Sep 16, 2013
I have a table of data with two rows of unqiue identifiying information. I am trying to develop a formula that will allow me to do a vlookup twice, once for each row of unique identifying information to retrive the value in same row for the third column. For example:
apple red 50
aaple blue 75
aaple yellow 80
apple green 90
grape red 12
grape blue 17
grape yellow 45
grape green 41
So, I am trying to do a lookup where I can say what is the value in the third column for apple and red. Or, what is the value in the third column for grape and green.
View 8 Replies
View Related
Dec 4, 2008
I have made a Pop Up Calendar for my worksheet Called frmCalendar.
How do i get it to activate as soon as a user clicks in the appropriate cell?
Can i get it to activate on a column (All cells in the column) as opposed to just a single cell?
View 9 Replies
View Related
Apr 22, 2008
I use Excel XP 2002. I now can't copy /paste by using the right mouse button. It works perfectly in other MS products, on the net and on the desktop. l have checked my Tools/Options with other users, I have uninstalled, rebooted and reinstalled the complete Excel package but the problem persists, even from start with a blank worksheet. I have also checked and there are no add-on ticked.
View 5 Replies
View Related
Feb 5, 2010
I have a large project that I've been able to move all code from the workbook to an Add-In (except code that's sheet related).
I have one module that refuses to run from the Add-In. In this code
View 2 Replies
View Related
Aug 28, 2009
I'm trying to design a form, for various staff members to populate.
I would like to ease their usage by putting a check mark in which ever cell they left click, also if they click a second time in the same cell it will undo the action.
I have not decided yet which which cells I am using, but is their some simple routine that could be used over & over again and all I would need to do would (hopefully) simply be to change the cell numbers in the routine to apply to that cell or range of cells.
View 9 Replies
View Related
Jul 29, 2006
I have a log that stores a list of different files in the first column. All of these files are worksheet hyperlinks (ie: =HYPERLINK("\USSS000010_PUBLIC5_COMMON15_PPA20066-032G6-032G.xls","06-032G")). If I click on any of these cells the file will open.
I am trying to open certain files from the list using VBA.
My question is Is there any way to simulate a mouse click, on the cell containing the hyperlink, using VBA?
View 9 Replies
View Related
Nov 2, 2012
I have a bit of code that I saved as an add-in. The code does a couple things: (1) Creates a right-click button that on action (2) draws a rectangular auto-shape that is the size of any selected range.
The add-in seems to loaded correctly.
However, when I launch a new excel sheet, my intent was to have the code (the right click option) be available whenever I opened Excel.
Is there another step to accomplish this?
View 7 Replies
View Related
Apr 30, 2014
If we mouse click any cell (right/left) it put √ symbol in that cell... How can I do it?
View 2 Replies
View Related
Jul 18, 2013
In excel when you have filters on for all columns there is a little bitty square box with a little down arrow (like an upside down triangle) in the lower right corner of every cell in the top row (the header row) and I can't find a way to select one of those little itty bitty down arrows without using a mouse - -
Is there any way to select one of those little down arrows in the little filter box icon thingy with the keyboard?? I can't figure it out.
I just want to select the little arrow so that the filter dialog box opens - I am trying to create a keyboard macro that will use the 'BEGINS WITH' macro but when i record the macro it uses the same word for the "BEGINS WITH" parameter every time and I want it to use the word in the current clipboard - can't seem to write that.
View 3 Replies
View Related
Mar 30, 2007
For instance if I want to cut a row and column, how do I insert with the keyboard without pasting over other data
View 9 Replies
View Related
Aug 29, 2007
I ask because I would like to change the value of a cell within A:A to TODAY() if the user right clicks on it - or with some keyboard combination.
View 9 Replies
View Related
Mar 12, 2008
my right mouse-clicker doesn't work in excel anymore. something with macros happened I guess.
has anybody an idea to activate it again?? it's just in the workfield, to change worksheets-colours and stuff at the worksheet-registry it works as usual.
it's very nasty to work in cells without mouse..
View 9 Replies
View Related
May 29, 2009
I want to select a function from a right mouse click that will place the current date in the selected cell.
Example:
1) Click on a cell
2) Perform a right mouse click
3) select the date function
4) the current date appears in selected cell
could this be set up so that the date function in the right mouse click only appears when specified cells are selected? Is this doable?
View 9 Replies
View Related
Feb 12, 2007
I have a list box with items. When I stay on item and press mouse right click, I want see pop up menu with "remove this item" and "add new item".
View 8 Replies
View Related
Aug 24, 2007
way, using VBA code, to disable/enable individual shortcut menu items that are are made available with a right mouse button click. The following code disables the right mouse button completely but I would like to disable only a couple of options like the ' Cut' option.
The code to disable is below and to re-enable I just change False to True.
Dim cb As CommandBar
i = 0
For Each cb In CommandBars
If cb.Type = msoBarTypePopup Then cb.Enabled = False
Next cb
View 9 Replies
View Related
Dec 6, 2008
I have a worksheet that I use to monitor the progress of student interns. They are assigned 20 different tasks and recieve 5 points for each task they complete, for a possible total of 100. In my worksheet, I record their progress and maintain a running total. I do this by simply inserting the number "5" by each cell containing each task. Instead of inserting the value, what I'd prefer to do is simply place my cursor, click the mouse button, and have a formattable check mark appear with a hidden value of "5". I'm simply trying to create a snazzy interface. Do I want too much? Or is it actually possible to do this?
View 14 Replies
View Related
Aug 23, 2006
I have a menu structure in place so when a user clicks a button, it opens a Userform as a menu. The only problem i have is that if the user doesnt want to use that menu, and clicks on the spreadsheet, it doesnt dissapear.
Is there any VBA code that anyone knows that when a user clicks on the spreadsheet, or even just clicks their mouse anywhere (ie other menus at the top, spreadsheet, desktop) like a mouseout code on HTML so the menu will dissapear?
View 9 Replies
View Related
Oct 2, 2013
A list box selection works fine on my computer but on a friends Windows Vista PC the following happens:
Selecting items near the top of the list works fine. 1/4 of way down a mouse click on an item selects the Next item.
1/2 of the way down in the list, the mouse click on an item selects the one 2 or 3 further down, etc., etc.
View 1 Replies
View Related
Jun 16, 2006
it would be possible to have text disappear after being displayed in Excel for a while.
My son and I played around with games (helping create a photographic memory, I told the youngster!) on the thing and until yesterday neither of us noticed that clicking the mouse anywhere (actually just clicking it) causes the screen to "freeze" while the code still happily erases the text in the background.
Hitting ESC allows the screen to cath up to the actual code EVEN THOUGH the ESC key is actually disabled from breaking the code.
View 9 Replies
View Related
May 31, 2007
I'm using code based on the following post: Add Borders To Cells Of Spreadsheet From Access. That code was developed for a relatively small recordest. I am using the same coding style to transfer a recordset that has roughly 2000 records in it. Since this is all taking place over a network there is a period of time (about 15-20 seconds) where Excel is open and the user is watching the cells get populated from Access. If, during that period of time when Excel is open, the user clicks in a cell during the population of data, it stops the process and causes an error on the Access end (Error 50290: Application-defined or object-defined error). Is there a way I can prevent user input (perhaps prevent signals from the keyboard and mouse) until after the data has been transferred? I know this is a long way to do a TransferSpreadsheet command but I like the way the column headers get formatted as well as the column sizes. I also think it's pretty cool to watch the data populate as it goes.
View 2 Replies
View Related
Jun 11, 2009
I am trying to write some questions on cells of Sheet1 of a workbook. Then I want to write the answers on cells of Sheet2 of the same workbook. I want the user to be able to double click the question-cell on Sheet1 and be taken to the respective answer on Sheet2.
View 6 Replies
View Related
Sep 30, 2009
I have a spreadsheet that just uses the basic "SUM" function. This morning I went to use it and the function does not work after I change a number within the field of that function. If, however, I go into the SUM function and double click, then hit enter, it does the new calculation.
View 3 Replies
View Related
Jun 1, 2014
I'm trying to simplify some data entry on an excel sheet, by making a double click vba to add a time any where in 2 columns, specifically H and I .
[Code] ....
I tried to modify this code but my understanding of VB is very lacking.
View 10 Replies
View Related
Jul 28, 2014
I have this list of all rangenames in my workbookin column A:A
For some reason I want to doubleclick on the rangename in the list to activate this range.
The reason is that I want more smooth activation-prosess; The Excel Range List is too long to practical use as a direct lookup, so I want to activate directly from my own list (where i have added definitions to the range names.
I have tried to build a hyperlink formula, but failed. Maybe the macro below can be modified to do the job, but I am stuck here as well.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim RangeName
Application.ScreenUpdating = False
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A:A")) Is Nothing Then
Cancel = True
[Code] ...........
View 2 Replies
View Related
May 12, 2009
I seem to have broken something!. Whenever I double-click to open an Excel file (.xls files are associated correctly), Excel opens, but nothing happens. That status bar says "Ready," but my workbook never appears.
If I do a File-> Open within Excel, then I am able to open the workbook. I have no idea what is going on. This occurs for all Excel files whether they contain macros or not.
View 9 Replies
View Related