Posted to microsoft.public.excel.programming

Gixxer_J_97[_2_] Gixxer_J_97[_2_] is offline

external usenet poster

Posts: 206

control toolbox objects and formulas

hi all,

is it possible to reference an object in a formula?
ie if a checkbox object exists on the worksheet, can something like this be
done:

=IF(CheckBox1=TRUE,"1","0")

tia

J

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
Where is the control toolbox?	John	New Users to Excel	0	November 30th 06 12:36 PM
Control Toolbox	[email protected]	Excel Discussion (Misc queries)	3	July 20th 06 03:10 PM
Control toolbox	HISNA	Excel Worksheet Functions	0	March 9th 06 05:14 PM
Controls Toolbox control vs Form Toolbox control	Tony_VBACoder	Excel Programming	3	January 28th 05 08:30 AM
Including control toolbox objects in tab order	Dan Harris	Excel Programming	0	August 13th 03 11:35 PM

All times are GMT +1. The time now is 03:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us