How to select a particular line in multi line text box

[angsuman]

Hello All,


Need help on how to select a particular line in multi line text box. I have a text box with multi line which contains several line with name of countries. I perform single click on one of the country and expect that particular line will be highlighted. Followup action will be delete the line if delete command button is selected. Which event of text box should I select to know the position of cursor when a line is clicked? I do not see any click event on text box.


Thanks
Angsuman

 

[My Aswer Is This]

You said:

in multi line text box

So this is not a activex Textbox

So your talking about a Text Box from the Insert Menu
Not a TextBox from the Developer

You can have lots of lines but this is not considered as Multiline
Or explain exactly what type control your talking about please.






​

 

[angsuman]

I am using an user form and text box control is added to user form from tool box. The text box property is set as multi line = True and EnterKeyBehaviour = True. Tool box is not added dynamically. Hope this makes sense.

 

[My Aswer Is This]

Well knowing this is on a UserForm Help
But I'm not sure how to do what you want.
Maybe someone else here at Mr. Excel will be able to help you

I have never used a Multiline TextBox

 

[My Aswer Is This]

So how are you entering all these values into the Textbox?

Your surely not entering them manually and then wanting to delete one after entering it.

 

[angsuman]

I can either enter data manually one by one or I can copy and paste it inside the text box. However I am doing it now by copying and pasting it inside the text box. I think I need to get the cursor position once I click on any text. Based on the cursor position probably I will find out line number or locate the text. Once this is done, I can select it and then delete. However I do not see any option to get the location of the cursor once I click on any text inside the text box.

 

[My Aswer Is This]

I really do not think a vba script will be able to do this. But maybe there is and I will learn something also.

Maybe I should ask.
What is your ultimate Goal.

What will you do with this data after entering it?