drag and drop

  1. Jaafar Tribak

    Worksheet_Change(ByVal Target As Range): How was the Target Range changed ?

    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...
  2. H

    Disable Drag and drop for a particular range in Worksheet

    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()...
  3. X

    Drag and drop cell by selecting any place inside a cell

    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...
  4. R

    GREP software for EXCEL integration

    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...
  5. C

    Annoying clipboard error

    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...
  6. kpasa

    Userform TreeView - Drag and Drop files from Explorer and Outlook attachements

    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 =...
  7. F

    Disable Drag and drop and workbook closed by error 400

    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...
  8. RyanTG

    Drag & Drop Calendar like Gmail?

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

    Drag and Drop Cell contents into UserForm Textbox ?

    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...
  10. Jaafar Tribak

    Drag and Drop Pseudo-Event !

    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...
  11. A

    Problems Copying a column pattern

    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...
  12. C

    Populate cells from list box drag/drop, can't find first empty row on worksheet

    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...
  13. S

    Help with drag and drop auto fill

    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...
  14. D

    How to drag and drop path of a file into textbox in vba ?

    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 ?
  15. Jaafar Tribak

    Very Cool DragListBox that enables the user to move Items from one Position to another !

    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...
  16. R

    Drop Multiple Files/Folders to VBS File

    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...
  17. Z

    Create shortcut to document by dragging to Excel

    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...
  18. R

    Drag and drop cells-turn it off?

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back