msg box and or sheet events

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

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.
 
can the msg box be set up in such a way that excel is
not "frozen" so that the user can select a range
 
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
 
Back
Top