Click a button and add info to where the cursor was on the last text box.

[Jordan]

How do I find out where the cursor was last in a text box. For example I
will use the | for the cursor in the following:

Bob has purchase | from us last week.

Now I want to have a list box with all our items in it so the user can click
one of the items and it gets inserted right where the cursor was. So the
text box should end up looking like:

Bob has purchase shovels from us last week.

 

[Jeanette Cunningham]

Hi,
something like this.
Forget about trying to find where the cursor was last in the textbox.
After the user has made their selection from the listbox set the value of
the textbox.
Me.txtbox = "Bob has purchased " & me.listbox.Column(1) & " from us last
week."

Jeanette Cunningham