Solved

How to automatically paste text to cursor site within text entered into a UserForm textbox?

Posted on 2014-10-23
4
129 Views
Last Modified: 2014-10-23
My user needs to type freehand notes into an Excel UserForm textbox control. But this requires the accurate spelling of some words that are easy to mis-spell, and accuracy is required.  So, at the side of the Userform, I can provide the user with a list of these 'tedious' spellings, each in the form of caption text in a UserForm label control.

In the model below, I can replace text in UserForm textbox with new copied text, or I can append new copied text to existing text. But:

MY QUESTION: how do I inset the copied text into existing text at a position marked by the Cursor in the text box?

MY MODEL (attached file):
When the user clicks a label control (in code below ctl.name = "Label1" ) its caption text is copied to clipboard:

Private MyData As New DataObject

Private Sub Label1_Click()
    MsgBox "Copy active in Label1_Click()" 'visual check that click event works
    MyData.SetText Label1.Caption
    MyData.PutInClipboard
End Sub

This pastes copied text into textbox1:

Private Sub pasteText_Click()
    TextBox1.Text = MyData.GetText
End Sub

I can append the copied text to existing text in texBox1 by:
TextBox1.Text = TextBox1.Text & " " & MyData.GetText

Thanks
Kelvin4
Paste2TextBox.xlsm
0
Comment
Question by:Kelvin4
  • 2
  • 2
4 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 40399675
You can use:

Private Sub pasteText_Click()
    TextBox1.Paste
End Sub
0
 

Author Comment

by:Kelvin4
ID: 40399694
Yes, but my question (above) is about the positioning of the pasted text at a position marked by the cursor in the text box:

"MY QUESTION: how do I inset the copied text into existing text at a position marked by the Cursor in the text box?"
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 40399746
This code will paste on the current cursor position
0
 

Author Closing Comment

by:Kelvin4
ID: 40399773
Thanks, quite correct and very quick response! Kelvin
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question