Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing textbox properties from Access VBA
I have code in an Access VBA module that creates a workbook in Excel. I am trying to create and manipulate an Excel textbox. I am able to create the textbox, and place text in it, but how can I change the background color? This doesnt work: With .ActiveSheet.Shapes("Text Box 2") .ShapeRange.Fill.ForeColor.SchemeColor = 39 End With This also does does not work: .ActiveSheet.Shapes("Text Box 2").Select objExcel.Selection.ShapeRange.Fill.ForeColor.Schem eColor = 20 However, this *does* work: With .ActiveSheet.Shapes("Text Box 2").TextFrame .Characters.Text = "My Text" End With note: objExcel is an Excel.Application object by the way, for no apparent reason in this post, there is incorrectly a space showing up in "SchemeColor", but thats not my code -- justme0010 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bind a textbox to Access data | Excel Discussion (Misc queries) | |||
Returning Access Table properties to Excel | New Users to Excel | |||
Cell changing it's properties | New Users to Excel | |||
What do i enter in the server textbox to access olap? | Excel Discussion (Misc queries) | |||
How can I access/display File -> properties in a cell | Excel Discussion (Misc queries) |