View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default How to change textbox caption in Active sheet from UserForm

You have to be in design mode and then change the property.

1) from worksheet menu - View - Toolbars - Control Toolbox
2) Press triangle to enter or exit Design Mode. It toggles back and forth
3) Press the tesxt box then press Properties ICON in the Control toolbox
toolbar.
4) Change the caption.

"mba1976" wrote:

Hi there,

I have a textbox1 in Active sheet (Sheet1).
How do I change the caption of this textbox1 from userform command button 1?


Thanks,