VBA Code that inserts cursor into a textbox

[jonstw]

Hi,

I am working with Excel 2007 in windows xp, I have a textbox that has been inserted in a worksheet by using insert shapes in the toolbar. I would like to run a macro that will position the cursor in the text in the textbox. The position does not matter. I have named the textbox "TextBox2".

Does anyone know of a code that will do this? or does it have to be an ActiveX control textbox?

Thank you for the help.

 

[BrianExcel]

An ActiveX would be easier. Why does it have to be a regular shape?

 

[BrianExcel]

Also, what process did you use to "Name" your text box?

 

[jonstw]

That is what I was afraid of. I have about 50 textboxes in the file and I inserted them as shapes before I even learned about ActiveX controls. Therefore I was kind of hoping I did not have to re-do the file and replace the ones I already have.

I named the textboxes by just selecting the textbox and replacing the name in the bar in the left hand corner next to the function bar.