linking check box to a formula

[bcwill]

Want to simplfy a large tracking spread sheet. Looking for a way to link a check box to generating the current date. Anyone figure this out before?

 

[Denise]

I have recently discovered the benefits of combo-boxes and drop down lists for large spreadsheets. If you explain more about what you're trying to do I may be able to help.

Denise

 

[NateO]

BC, I picture the following lending itself to what you're talking about.

Dim cb As CheckBox

For Each cb In yourDlg.CheckBoxes
If cb.Value = xlOn Then
application.run("YOUR MACRO NAME")
End If
Next cb

Substitue yourDlg for the name of your Dialog and "YOUR MACRO NAME" for the name of a macro that generates the date (MsgBox (Date)), etc...

borrowed this from:

http://www.mrexcel.com/board/viewtopic.php?mode=viewtopic&topic=201&forum=2&start=0

Cheers,

Nate
This message was edited by NateO on 2002-02-20 15:35