Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the formula property of a textbox
After creating a textbox:
Worksheets(ActiveSheetName).Shapes.AddTextbox.Sele ct I try to set its formula (where sForm="Sheetname!B8"): this works: selection.Formula = sForm this does not: selection.Formula = "= " & sForm & " & "":"" " |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the formula property of a textbox
AFAIK the only type of formula you can put into a Textbox
or Label is a reference to a single cell, such as you have successfully been able to do. (Manually - select Textbox, select input-bar, type an =, then the reference). As a workaround maybe you could put your desired formula in a cell (possibly hidden, or on another sheet) then reference this cell in your Textbox. If my "AFAIK" is wrong I'm sure someone will be good enough to correct! Regards, Peter -----Original Message----- After creating a textbox: Worksheets (ActiveSheetName).Shapes.AddTextbox.Select I try to set its formula (where sForm="Sheetname!B8"): this works: selection.Formula = sForm this does not: selection.Formula = "= " & sForm & " & "":"" " . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error setting shape text property | Charts and Charting in Excel | |||
Textbox ControlSource Property - Excel 97 | Excel Programming | |||
Setting the Values Property of the Series Class | Excel Programming | |||
Setting TopMargin Property in VBA | Excel Programming | |||
setting formula property | Excel Programming |