Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox
I want to write some vba code that when the user enters the BeforeSav
event, it will save the content of text boxes that have been inserte into a chart onto another excel workbook. how would i go about doin that -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox
So I'm trying to play around with the text boxes a bit so I can hopefully figure it out for myself. I don't understand this error I'm getting in the code below. If I use the code below, I get a Run-time error '91': Object variable or With block variable not set. I understand what the error is saying but I don't understand why its occuring because if I change ActiveChart.Shapes to ActiveSheet.Shapes, it works fine. Can someone please explain this to me? Thank
Dim oObj As Shap For Each oObj In ActiveChart.Shape If oObj.Type = msoTextBox The oObj.DrawingObject.Font.Size = 2 End I Next oObj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
TextBox | Excel Programming | |||
to textbox | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |