Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show A userform on selection range
Hi,
Is it possible to show a userform when the user selects a cell (enters the cell), I can use the selectionchange but is there a on cell enter /selection? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show A userform on selection range
Hi Sanjay, I am not sure that I understand your distinction between the
Selctionchange event and " on cell enter /selection" , but perhaps your intention is to limit the event response to a single cell or range. Try, therefo '============= Private Sub Worksheet_SelectionChange _ (ByVal Target As Range) Dim rng As Range Set rng = Me.Range("A1") '<<==== CHANGE If Not Intersect(rng, Target) Is Nothing Then UserForm1.Show End If End Sub '<<============= --- Regards, Norman "Sanjay" wrote in message ... Hi, Is it possible to show a userform when the user selects a cell (enters the cell), I can use the selectionchange but is there a on cell enter /selection? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show A userform on selection range
Thanks Norman,
What I'm after if possible is that when the user clicks a cell, the userform is displayed, but at the moment the only option I can see is if the cell is changed then the userform can be displayed. Thanks! "Norman Jones" wrote in message ... Hi Sanjay, I am not sure that I understand your distinction between the Selctionchange event and " on cell enter /selection" , but perhaps your intention is to limit the event response to a single cell or range. Try, therefo '============= Private Sub Worksheet_SelectionChange _ (ByVal Target As Range) Dim rng As Range Set rng = Me.Range("A1") '<<==== CHANGE If Not Intersect(rng, Target) Is Nothing Then UserForm1.Show End If End Sub '<<============= --- Regards, Norman "Sanjay" wrote in message ... Hi, Is it possible to show a userform when the user selects a cell (enters the cell), I can use the selectionchange but is there a on cell enter /selection? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show A userform on selection range
Hi Sanjay,
'----------------- What I'm after if possible is that when the user clicks a cell, the userform is displayed, but at the moment the only option I can see is if the cell is changed then the userform can be displayed. '----------------- Have you tried the code? The Worksheet_SelectionChange event responds to a change in selection; the Worksheet_Change event responds to a (non formula) value change. --- Regards, Norman |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show A userform on selection range
Norman,
That's what I was after thanks again! Regards, Sanj "Norman Jones" wrote in message ... Hi Sanjay, '----------------- What I'm after if possible is that when the user clicks a cell, the userform is displayed, but at the moment the only option I can see is if the cell is changed then the userform can be displayed. '----------------- Have you tried the code? The Worksheet_SelectionChange event responds to a change in selection; the Worksheet_Change event responds to a (non formula) value change. --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection of UserForm through button | Excel Programming | |||
FILTER: show/don't show selection with tickboxes | Excel Discussion (Misc queries) | |||
selection all textboxes in userform at once | Excel Programming | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Date Selection Userform | Excel Programming |