Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing Insert/Delete Events in Excel Sheet using c# | Excel Worksheet Functions | |||
events? | Excel Discussion (Misc queries) | |||
Capturing Sheet Events | Excel Programming | |||
events | Excel Programming | |||
events | Excel Programming |