Thanks a lot for the help.
-Original Message-
From: RolfJ [mailto:r...@pacificsound.us]
Sent: Tuesday, November 24, 2009 7:24 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Excel check list
If I correctly understand what you are trying to do you could add a
UserForm to
I am looking for something similar so can you send me a workbook with the
example as i am not familiar with VBA
THanks,
Dharmesh
On Mon, Nov 23, 2009 at 9:08 PM, RolfJ wrote:
> Here is a slight correction to my previous response. The eventhandlers
> in the ThisWorkbook VBA module need to be
Here is a slight correction to my previous response. The eventhandlers
in the ThisWorkbook VBA module need to be modified as follows:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
UserForm1.cmdButton.Caption = "Close Workbook"
UserForm1.Show vbModal
End Sub
Private Sub Workbook_Befo
If I correctly understand what you are trying to do you could add a
UserForm to your workbook, add five checkboxes and one command button
and then place the following code in its VBA module:
Option Explicit
Dim b_UserIsFinished As Boolean
Private Sub CheckBox1_Click()
cmdButton.Enabled = All
