Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Learning Macros and ActiveX controls...have a simple question...


Hello...

I am new to macros so please forgive me if I don't explain thi
clearly. I have a check box. When it is checked I need the formula i
another cell to recognize that it is checked and calculate the formula.
Can anyone help me with this?

Thanks

--
bizechic
-----------------------------------------------------------------------
bizechick's Profile: http://www.excelforum.com/member.php...fo&userid=1640
View this thread: http://www.excelforum.com/showthread.php?threadid=27778

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Learning Macros and ActiveX controls...have a simple question...

You could link the checkbox to a cell, and then pick up that linked cell in
your formula.

Linking a cell is a checkbox property, set it in design mode.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bizechick" wrote in message
...

Hello...

I am new to macros so please forgive me if I don't explain this
clearly. I have a check box. When it is checked I need the formula in
another cell to recognize that it is checked and calculate the formula.
Can anyone help me with this?

Thanks!


--
bizechick
------------------------------------------------------------------------
bizechick's Profile:

http://www.excelforum.com/member.php...o&userid=16408
View this thread: http://www.excelforum.com/showthread...hreadid=277787



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
remove macros, ActiveX controls, XML expansion pack info, or web c Justin Excel Discussion (Misc queries) 2 April 24th 23 03:45 AM
ActiveX Controls leerem Excel Discussion (Misc queries) 0 December 11th 08 01:11 PM
ActiveX controls Luke Excel Discussion (Misc queries) 1 October 26th 06 02:00 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
ActiveX Controls David Fixemer Excel Programming 4 February 16th 04 05:20 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"