Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a textbox ole/control
I'm trying to read and write text to all textboxes on a worksheet page. I
pulled off of a bunch of examples from this forum (including one of my own threads) and nothing is working. Can someone verify if there is something wrong with either of these methods below. Note that at this point in the code the worksheet is open and I've already read from objWS.cells. The page has two text boxes and two picture boxes, I don't know if they are OLE or controls. Neither method executes the loop at all. I'm using Excel 2003 and Windows 2000. Method 1, read an OLE textbox: For Each OLEObj In objWS.OLEObjects BBStr = OLEObj.Object.Text oIEDoc.Writeln BBStr Next Method 2, read a textbox control: For K = 1 To 5 BBStr = ActiveSheet.Controls("TextBox" & K).Text oIEDoc.Writeln BBStr Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox control | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
Reading from TextBox | Excel Programming |