-
Jan 28th, 2015, 02:21 PM
#1
Thread Starter
Lively Member
[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.
-
Jan 28th, 2015, 03:47 PM
#2
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|