linking check box to a formula

bcwill · Feb 20th, 2002, 03:42 PM

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 · Feb 20th, 2002, 04:02 PM

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 · Feb 20th, 2002, 04:31 PM

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/viewtop...orum=2&start=0

Cheers,

Nate

[ This Message was edited by: NateO on 2002-02-20 15:35 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 03:42 PM	#1
bcwill New Member Join Date: Feb 2002 Posts: 1	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?

Feb 20th, 2002, 04:02 PM	#2
Denise New Member Join Date: Feb 2002 Location: M&T Bank Posts: 18	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

Feb 20th, 2002, 04:31 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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/viewtop...orum=2&start=0 Cheers, Nate [ This Message was edited by: NateO on 2002-02-20 15:35 ]