[dba-VB] RRESOVED! E: VBA Excel Validation

Shamil Salakhetdinov shamil at users.mns.ru
Sat Feb 9 10:20:27 CST 2008


Congrats! :)

--
Shamil
 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Saturday, February 09, 2008 6:34 PM
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: [dba-VB] RRESOVED! E: VBA Excel Validation


It was actually working at the workbook level. I hadn't closed the first
message box while I was trying the other sheets and the message box went to
the background (I've never seen this before and can't reproduce it) Doesn't
really matter. It's working, thanks.

John


-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Saturday, February 09, 2008 10:26 AM
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] VBA Excel Validation

Shamil,


I may be asking you a few questions over the next few days as I'm working on
a new project so if they are basic questions, bare with me.

I was successful in using the BeforeDoubleClick event on a 'sheet', but want
it to work for 'every sheet' without having to add the code to every sheet.

I tried the following at the 'workbook' level for testing and hoped it would
be global across all sheets. Am I thinking about this in the wrong way?

Here is the code:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target
As Range, Cancel As Boolean)
  MsgBox "The Target Is " & Target
  MsgBox "The Target Name Is " & Target.AddressLocal
End Sub




_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com




More information about the dba-VB mailing list