I've a question.Please

[utkuozel]

I want to delete in textbox in VBA.
how can i do it?

 

[TroyMcClure72]

do you really want to delete it?

You dan just hide
TexboxName.Visible = False

Or disbale it
TextboxName.Enabled = False

 

[xlbo]

delete the text IN the textbox or delete the textbox ???

Either way, a VERY quick perusal of the help files will give you the answer

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[fumei]

And you need to state what kind of a textbox. Is this a textbox on a UserForm? Plus we have no idea what application you are using. Is this for Word? Is this for Excel? What?

If Word, is this a Form Field textbox? Is this an ActiveX control textbox? Is this a texbox created with Insert > Textbox, in which case it is neither a Form Field textbox, OR an ActiveX control textbox, it is an InlineShape textbox.

Actually Troy and Geoff's question are crucial. Do you want to delete the contents, or the box itself; do you want to hide it, or really delete it?

Gerry