Check Box comment

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi Group,

I have a very simple request. I have an excel spreadsheet setup as a
check list for a very complicated audit process. I am using MS Excel
2003 and using the Check Box on this check list.

What I want to do is when a person clicks on a check box on this
worksheet I want Excel to popup a message saying "Please Fill the
Related Entities Spreadsheet, thanks" & that it. I was thinking of a
macro that could do this.

thanks in advance,
 
Draw a checkbox using the Control Toolbox.

Right-click and "View Code"

Add this line MsgBox "doodah, doodah" which will give you this.

Private Sub CheckBox1_Click()
MsgBox "doodah, doodah"
End Sub

Exit design mode and click on checkbox.

There may other ways to do this.

What would prompt the user to click the checkbox?

Might be better instead to use some change_event code that is triggered when
user completes filling in data in a range.

No need for user to click anything.


Gord Dibben MS Excel MVP
 
Draw a checkbox using the Control Toolbox.

Right-click and "View Code"

Add this line    MsgBox "doodah, doodah"  which will give you this.

Private Sub CheckBox1_Click()
    MsgBox "doodah, doodah"
End Sub

Exit design mode and click on checkbox.

There may other ways to do this.

What would prompt the user to click the checkbox?

Might be better instead to use some change_event code that is triggered when
user completes filling in data in a range.

No need for user to click anything.

Gord Dibben  MS Excel MVP






- Show quoted text -
Click to expand...

Thank You I will look in to the Change_event code that you mentioned.
As it stands now the macro is firing everytime a user clicks on the
check box ,I do not want to fire this macro if the user unchecks this
check box,


Like I said this is a check list and the user is going down a long
list clicking check boxes and on certian items I want to prompt them
to fill other related spreadsheets.

thanks Dave
 
Hi Dave
One more way if your form will allow it, If your check box is from the Control
Toolbox,
you must be in design mode, right click on the check box and goto Properties,
find "Linked Cell
type any cell you like, it could be behind the check box, then if you don't wont
to see the information on that cell, you will get "True / False" just colour
your text white.
In a cell where you want to show the text "Please Fill the
Related Entities Spreadsheet, thanks",
type this formula. I'm using B2 as my linked cell .
=IF(B2=TRUE,"Please Fill the Related Entities Spreadsheet, thanks","")
HTH
John
 
Back
Top