drag and drop

Hi all, Worksheet_Change(ByVal Target As Range) The worksheet change event tells us which Range (Target) was edited but doesn't tell us how. As we know, the user can change a cell either, by editing it with the keyboard, by pasting a value into it ,by drag and drop or by using the autofill...

I have a worksheet A , in which I want to disable dragging functionality for a particular range of cells. for eg: D24 to D100 All other columns and cells in the sheet should be allowed to drag. Found this code, but its for the complete workbook : Private Sub Workbook_Activate()...

Hi, I like to move cells around the sheet in my work, to do so, you have to select border of the cell, only then you can move the whole cell. My question: is it possible to enable either through settings or VBA - ability to move cells by selecting any place inside the cell, not only the corner...

i am using a GREP application to search for data in files that match a criteria and I want to get the results into EXCEL Can i drag and drop or can i pass a selection back from a file to EXCEL? Also does it matter if the file is already open (Highlight a file on an already open Windows Explorer...

I searched for an answer on this but as common as the error seems to be didn't find one. Dragging data from one cell to another returns "There's a problem with your clipboard but you may still paste your content within this worksheet." It makes no difference what size the worksheet is or what...

I have a userform with a TreeView being used as a "Drag and Drop" file input. The goal is to have the userform automatically accept that file and copy it to a specified folder. So far i have this code in my userform_activate: TreeView1.OLEDropMode = ccOLEDropManual TreeView1.OLEDragMode =...

Hello, I want to disable drag and drop in my workbook. So I put this code in "ThisWorkbook" : Private Sub Workbook_Activate() Application.CellDragAndDrop = False End Sub Private Sub Workbook_Deactivate() Application.CellDragAndDrop = True End Sub It works, but when another vba code...

Is it possible to create a calendar in excel like gmail where you can drag and drop events to different days?

Hi all, I have a modeless userform with a textbox in it .. I would like to be able to drag and drop cells into the textbox but excel doesn't allow the drag and drop operation .. instead, the cell content is dropped into the cell right behind the userform textbox .. the DragBehavior Property of...

Motivated by the question posted here , I have managed (I hope) to simulate a Before drop event for cells/ranges Workbook Example The signature of the pseudo event is written in line with the standard office events format for an easy and a more intuitive use .. setting the Cancel argument to...

Hey everyone. I'm having an issue using the pull/copy (dragging by the corner) for a pattern that skips columns from another sheet. Example (This is my formula for the first 5 rows, but I need to copy them down keeping the pattern going until 340) NPC'!$B$7 NPC'!$E$7 NPC'!$H$7 NPC'!$K$7...

Hello, I am running Excel 2010 and Windows 7. I have been working on this project for several weeks and this problem has eluded me from nearly the beginning. See Photo I have a form with a main list box and several other list boxes. I drag and drop records from the main list box to the...

Hi, I hope someone can help. I Have a number of identical worksheets all with mulitple formulas contained within and i am looking to create a summary sheet i have used the $ sign to stop the rows increasing as i drag and the formula but i cant get the sheets to increase by an increment of 1...

I have created a form in excel via VBA It is having a textbox. I want to drag an file path in to the textbox by droping the file in the textbox. Can any body help ?

WorkBook example. Hi all. I have been working hard on this one and hopefully ,at last, I seem to have achieved some nice results : Basically, the code creates a real ListBox Control from scratch and subclass it to make it a Drag listbox and to capture other events as well. All done in...

I've got a VBS file that I'm using to populate an excel spreadsheet with file names. I select the files (.pdf's or .slddrw's of mechanical drawings) and drop them on the script, it iterates through the files and puts them into the spreadsheet with their folders. My problem is that I can only...

Hi everone, I would like to make a reference or index file from where i can open other documents. The documents are located in several folders and subfolders. To keep it userfriendly i would like the option to drag and drop the document to the excel 'index'-file which creates a shortcut to...

I'm having trouble with a spreadsheet, in that users have a nasty habit of putting data into the wrong cells, then dragging them where the data is supposed to go, which, of course, drags the formulas, messes up calcuations elsewhere on the sheet, and creates mass chaos. I know I can turn off...