Results 1 to 2 of 2

Thread: Textbox values in modules using Excel VBA

  1. Jul 25th, 2005, 12:04 PM #1
    midengine210
    midengine210 is offline

    Thread Starter
    New Member
    Join Date
    Jul 2005
    Posts
    2

    Textbox values in modules using Excel VBA

    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.
    Reply With Quote Reply With Quote
  2. Jul 25th, 2005, 03:44 PM #2
    midengine210
    midengine210 is offline

    Thread Starter
    New Member
    Join Date
    Jul 2005
    Posts
    2

    Re: Textbox values in modules using Excel VBA

    Nevermind. I figured it out.

    ActiveSheet.TextBox1.text
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width