Prev: How do I draw shapes on a user form? (VBA Excel 2007)
Next: OleObject-Preventing deletion
From: sarndt on 27 Jan 2010 19:01
If I know the name of a textbox object that exists on my worksheet, how can I
get the value of the textbox object based on the textbox name in my class
module?

Thanks

Steve


From: Joe User on 27 Jan 2010 19:51
"sarndt" <sarndt(a)discussions.microsoft.com> wrote:
> Subject: Class Programming

Some people in these NGs have a knee-jerk objection to helping people with
class programs. :-) :-) :-)

(Steve, no criticism of you intended. Wish I could help you myself.)


----- original message -----

"sarndt" <sarndt(a)discussions.microsoft.com> wrote in message
news:4F6E05B3-F4EA-41A6-8064-75FF7BBCC757(a)microsoft.com...
> If I know the name of a textbox object that exists on my worksheet, how
> can I
> get the value of the textbox object based on the textbox name in my class
> module?
>
> Thanks
>
> Steve

From: Tim Williams on 27 Jan 2010 23:52
http://ask.metafilter.com/57503/How-to-iterate-through-controls-in-VBAExcel


Tim

"sarndt" <sarndt(a)discussions.microsoft.com> wrote in message
news:4F6E05B3-F4EA-41A6-8064-75FF7BBCC757(a)microsoft.com...
> If I know the name of a textbox object that exists on my worksheet, how
> can I
> get the value of the textbox object based on the textbox name in my class
> module?
>
> Thanks
>
> Steve
>
>


 | 
Pages: 1
Prev: How do I draw shapes on a user form? (VBA Excel 2007)
Next: OleObject-Preventing deletion