Prev: Help changing Keyboard Shortcut assigned to Excel Macro
Next: Redefining a table range with a macro
From: Joe on 21 May 2010 07:28
I want to change the text of a form.
I know the name of the form and the name of the control in it.

How to get the control of a form if I know the Name?

Below post refers to adding a form. But I already have a form, just
need the control of that!
http://groups.google.co.in/group/microsoft.public.excel.programming/browse_thread/thread/beedb666e1d7a29b/f2df993ded867dd4?hl=en&lnk=gst&q=form+by+name#f2df993ded867dd4

Thanks a lot in advance

Regards'
Joe
From: joel on 21 May 2010 08:28

If you are talking about a VBA user from in VBA window press F4 (View
properties window) and click on the control. The name will be in the
Name property.

If you have a worksheet user form you should be able to click on the
object and the name will be in the box next to the formula box (fx)


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=204280

http://www.thecodecage.com/forumz

From: Joe on 21 May 2010 08:43
But I need it in runtime !
From: Joe on 21 May 2010 08:44
On May 21, 4:28 pm, Joe <joe.varghese.j...(a)gmail.com> wrote:
> I want to change the text of a form.
> I know the name of the form and the name of the control in it.
>
> How to get the control of a form if I know the Name?
>
> Below post refers to adding a form. But I already have a form, just
> need the control of that!http://groups.google.co.in/group/microsoft.public.excel.programming/b...
>
> Thanks a lot in advance
>
> Regards'
> Joe

I got a very Nice Link...
http://www.cpearson.com/excel/ShowAnyForm.htm

I am trying it out...
From: Rick Rothstein on 21 May 2010 11:25
Your description is somewhat confusing... can you give more detail about
what you are actually trying to do?

--
Rick (MVP - Excel)



"Joe" <joe.varghese.john(a)gmail.com> wrote in message
news:aa0afd18-fcb5-41e8-9324-cb94cf3c3352(a)u3g2000prl.googlegroups.com...
> I want to change the text of a form.
> I know the name of the form and the name of the control in it.
>
> How to get the control of a form if I know the Name?
>
> Below post refers to adding a form. But I already have a form, just
> need the control of that!
> http://groups.google.co.in/group/microsoft.public.excel.programming/browse_thread/thread/beedb666e1d7a29b/f2df993ded867dd4?hl=en&lnk=gst&q=form+by+name#f2df993ded867dd4
>
> Thanks a lot in advance
>
> Regards'
> Joe

 |  Next  |  Last
Pages: 1 2
Prev: Help changing Keyboard Shortcut assigned to Excel Macro
Next: Redefining a table range with a macro