| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically Adding Textbox To Frame
How do I add a textbox control to a frame object (declared as OLEObject) in
vba code behind a worksheet? For example, I have tried the following that doesn't work... Dim objFrame As OleObject Set objFrame = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Frame .1") With objFrame .Object.Controls.Add ClassType:="Forms.Textbox.1" End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding values in first "X" number of rows dynamically | Excel Worksheet Functions | |||
| Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
| Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
| frame | Excel Discussion (Misc queries) | |||
| How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
Hybrid Mode
