Results 1 to 2 of 2

Thread: [RESOLVED] VB6 and Excel TextBox Object

  1. #1

    Thread Starter
    Lively Member ghettohacker's Avatar
    Join Date
    Dec 2005
    Posts
    81

    Resolved [RESOLVED] VB6 and Excel TextBox Object

    I am working with an existing Excel document and VB6. I need to open the document, enter some data into a Textbox object within an excel sheet.

    I can open the excel document as normal, but I am having trouble trying to figure out how to reference the textbox object that it contains to add text to it.

    Any help with referencing and adding text to a textbox in excel would be awesome.

  2. #2

    Thread Starter
    Lively Member ghettohacker's Avatar
    Join Date
    Dec 2005
    Posts
    81

    Re: VB6 and Excel TextBox Object

    Ok, so I finally figured it out in case any one else need its.

    Once I had a reference to a sheet ie. Set oSheet = oWB.ActiveSheet

    I was then able to use:

    oSheet.Shapes.Item("TextBox 4").TextEffect.Text = "woo"

Tags for this 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
  •  



Click Here to Expand Forum to Full Width