msg box and or sheet events
 

I want to trigger an event by changing the format(we
change the fill colour) of a cell.The change event isnt
triggered by changing the fill colour.Other wise i can
prompt the user with a msg box to select a range but excel
is frozen while the msgbox appears.

msg box and or sheet events
 

Hi Paul
AFAIK there is no event which is triggered by a format change

--
Regards
Frank Kabel
Frankfurt, Germany

paul wrote:
I want to trigger an event by changing the format(we
change the fill colour) of a cell.The change event isnt
triggered by changing the fill colour.Other wise i can
prompt the user with a msg box to select a range but excel
is frozen while the msgbox appears.

ok then...msg box
 

can the msg box be set up in such a way that excel is
not "frozen" so that the user can select a range
-----Original Message-----
Hi Paul
AFAIK there is no event which is triggered by a format
change

--
Regards
Frank Kabel
Frankfurt, Germany

paul wrote:
I want to trigger an event by changing the format(we
change the fill colour) of a cell.The change event isnt
triggered by changing the fill colour.Other wise i can
prompt the user with a msg box to select a range but
excel
is frozen while the msgbox appears.
.

ok then...msg box
 

Hi Paul
if you want to ask the user for a range selection (to process this
selection in your code) you may use the following

Sub foo()
....
Dim rngAs Range
On Error Resume Next
Set rng= Application.InputBox(prompt:="Select range:", Type:=8)
If Err < 0 Then
Exit Sub
End If
On Error GoTo 0
' Now you can use rng as range object with your user's selection
....
End Sub


--
Regards
Frank Kabel
Frankfurt, Germany

paul wrote:
can the msg box be set up in such a way that excel is
not "frozen" so that the user can select a range
-----Original Message-----
Hi Paul
AFAIK there is no event which is triggered by a format change

--
Regards
Frank Kabel
Frankfurt, Germany

paul wrote:
I want to trigger an event by changing the format(we
change the fill colour) of a cell.The change event isnt
triggered by changing the fill colour.Other wise i can
prompt the user with a msg box to select a range but excel
is frozen while the msgbox appears.
.