Textbox values in modules using Excel VBA [Archive]

midengine210

Jul 25th, 2005, 12:04 PM

I'm new to VBA and am having some problems accessing the value of a textbox that I created in Excel using the control tool bar. I want to pull that value into a sub routine that I have written in a module. I tried the following, but have had no success.

value = ActiveSheet.TextBoxes("TextBox1").text

Any help is appreciated. Thanks in advance.

midengine210

Jul 25th, 2005, 03:44 PM

Nevermind. I figured it out.

ActiveSheet.TextBox1.text