double

Hey all, I would like to send an email from my listbox when i double click a name on it. Situation: Listbox named lstSearchResults Data that is displayed in it: Fullname, Department, Gender, Phone, Email So when i double click on a name in the listbox i would like to be able to send a email...

CROSSPOSTED FROM HERE. Hi everyone. I have a problem with my VBA code. I have certain functions SUM_DIST and SUM_DISTN that require a range of cells as input. Both are working fine and in order. SUM_DIST has to be ran only once, then SUM_DISTN has to be run thrice, with SUM_DISTN requiring...

Good Evening- Running excel 2016- not sure why- but excel recently has started a funky method of opening projects. If I double click a workbook saved on my desktop, it opens up excel with no workbook loaded. I then have to go back to the desktop and double click the workbook again to load...

Is there a way for me to declare a variable in a UDF so that it will be available to any UDF that it calls? I tried Public varname as double Global varname as double but they both got error messages. A search turned up several webpages about global variables, but they all seem to indicate...

Couple of questions. I want to apply an advanced filter based on the cell that is double clicked. This works Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Global_Filter End Sub I have a few questions 1. The Sheets "Data" is deleted and recreated as...

Hello,</SPAN></SPAN> Highlights different column on double clicking. </SPAN></SPAN> For example double clicking (highlight multicolumn) on cell N12-highlihght 2 columns C12:D42, on cell O12-highlihght 4 columns C12:F42, on cell P12-highlihght 6 columns C12:H42 </SPAN></SPAN> For example...

Hi all I am using this code to fill in numbers in sequential order when double clicking in a cell. So, if number 1 is in F1 and I double click in F10, 2 thru 10 will autofill down. The issue that I am having is that it is copying the format as well. I would like just the values to copy down...

Hi,</SPAN></SPAN> I need when I double click into any cell in K:L columns highlight cells in the column C</SPAN></SPAN> When I double click into any cell in P:R columns highlight cells in the column D</SPAN></SPAN> When I double click into any cell in U:V columns highlight cells in the column...

Hi, I am wanting to simulate double clicking in a selected range as I have an 'almost complete macro' that only seems to work when I have double clicked in the specific cells. I have come up with this code but it does not seem to work compared to when i physically double click each cell. Can...

Hello- continuing tweaking a module. The module takes data from a bunch of cells and runs a series of formulas (via a button) and the answer comes up in a msgbox. Obviously if a critical cell doesn't have data, it'll stop everything. I started some of the coding for one of the modules (there...

I have a function from which I am passing data to a subroutine and then populating the output. When I am using x, y as is, I am getting the output, but when I use arr1, arr2 instead I do not get an output. The code is: Option Explicit Option Base 1 Public Function Func1(ByVal x As Range, ByVal...

Hello,</SPAN></SPAN> I want a code that can select or deselect offset entire column double clicking on cell.</SPAN></SPAN> For example if I double click on any cell in the column "L", I want entire column "C" could be selected. If I redo double click then entire column deselected</SPAN></SPAN>...

Hi The below code was kindly provided to me by somebody on the board many years ago and the layout of the relevant sheet has changed since then. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 7 Then TopCell = Cells(12, 3).Address BottomCell...

I'd like to make a macro to unhide a sheet by double clcking on a cell. The cell value would have the same name as the sheet. let's say I have this line: (A1) "Sheet1" : (A2) "NAME" : (A3) "NAME So by double clicking any were in the row 1 would unhide sheet "SHEET1" Also, is there a way to...

I'm doing a root finder using Newton's Method and it will run fine in my spreadsheet but when I do a step through i get an overflow runtime error and I'm not sure why. I've tried changing the variables from double to long but it doesn't seem to help. Option Explicit Sub NewtonMethod() '...

I have a sign in/out sheet That Columns D2:2000, E2:2000 once double clicked enter current time. what I need is that It can be only double click. and not manually entered. I already have the VBA code that enters current time on double click. Current codes are...

I use this to drag down alphabetical letters: =CHAR(CODE(A1)+1) It works, but only up to Z! What do I use to continue the sequence through to double letters like this: AA AB AC AD Thanks for your help!

Hi All, I have a dropdown list of about 30 lines. The dropdown list is in column N. Some examples of the format below. 2x25' 2x75' 2x100' 3x25' 3x50' 3x75' At times, I need an "s" to appear at the end like this: 2x100's So, instead of doubling the size of my dropdown list, I would like to...

Hi there, I would like to double click on a value within a sheet called Capacity, for it to be filtered out on another sheet, called Status. In Status, I have a table range already done called Details, and the column to be searched from is B4, any ideas? Thanks

Strange (to me at least) behavior from double clicking on a cell with data in a pivot table. Hoping someone can give me some insight. We're running Excel 2013 Professional on Windows 10 Enterprise. I have a pivot table using the "data model" functionality (i.e. in order to make "Count...