How to reference standard worksheet textbox in VBA

[Mikeymike_W]

Hi,

I was wondering how i would reference a textbox in VBA. I can do this no problem with activex textboxes but don't know how to do with a normal one.

I am wanting to use a normal textbox as the activex one is very laggy and takes forever to show the text you're typing.

Many thanks for your help,

Mike

 

[RoryA]

Sheets("sheet name").Textboxes("text box name") for example.

 

[Mikeymike_W]

Thats awesome, thanks so much Rory!

 

[RoryA]

Glad to help.