excelvbatextboxdragdrop
how can I drag text from one a textbox to another textbox in a userform
I have 20 textboxes in a userform and I want to move the text from textbox1 to textbox5 by dragging and dropping it with the mouse, but I really have no idea how to do this. I am not an experienced programmer in VBA so maybe it is not even possible
Solution
No VBA required! It is simple than you think :)
Set the DragBehavior of the TextBox to fmDragBehaviorEnabled at design time as shown below and you are done
In Action
- Dynamic array using xlwings causing formula to be wrapped with {}
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- VBA - Worksheet.activate not working
- How to split a string into a 2-dimensional array in vba?
- Filter Range C3:G3 And paste to other cells
- How to solve Excel VBA: Compile error in hidden module
- Conditional Format Cells with Special Characters including Accented Letters, Numbers, and Punctuation
- Activate worksheet from its userform
- Return the number of objects in a slicer from another workbook
- How do transform a "matrix"-table to one line for each entry in excel
- Non-Intersect Range VBA
- change color of shapes based on cell values vba
- Copy Raw Data and Paste into Visible Columns In Destination Sheet
- How to clear Sort in Excel 2007
- Excel VBA - How to find last row of range that contains any numerical value (not text)
- xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors
- How to fill fast for integer number calculation?
- Load Excel file into numpy 2D array
- Unprotect an Excel file programmatically
- How do I calculate Percentiles in PowerQuery based on grouping variables?
- Combine most recent 5 records into one cell in Excel
- How to add a date column with a condition?
- Excel VBA Findfirst equivalent between spreadsheets?
- Excel VBA - Remove everything but numbers and dots from string
- Finding a value by two criteria: by value and range in Exel
- Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel
- IF statement macro keeps moving cell