Posted to microsoft.public.excel.programming

external usenet poster

Posts: 35

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 & " & "":"" "

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error setting shape text property	Sarge	Charts and Charting in Excel	2	January 11th 06 03:31 AM
Textbox ControlSource Property - Excel 97	Tom Ogilvy	Excel Programming	0	June 17th 04 09:45 PM
Setting the Values Property of the Series Class	Alex A	Excel Programming	2	January 30th 04 08:55 PM
Setting TopMargin Property in VBA	John S.[_3_]	Excel Programming	2	October 17th 03 06:08 PM
setting formula property	Ed Stevens	Excel Programming	1	September 9th 03 04:59 AM

All times are GMT +1. The time now is 02:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us