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.
