Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Is it possible to have a userform display (show) on selection of a specific cell? I have come up with the code as below but it shows the form on everytime I select any cell and not just "B18". Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' Want userform to display on selection of cell B18. ' If any other cell is selected - nothing. If Range("b18") = ActiveCell Then Call Furn Else ' "Furn" is UsrFrm.show If Range("b18") < ActiveCell Then Exit Sub End Sub Thanks for your help. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 - a "bar" is not showing | New Users to Excel | |||
Excel VBA question - showing userform when opening workbook | Excel Programming | |||
Showing Worksheet Range in Userform | Excel Programming | |||
Showing a userform based on a condition. | Excel Programming | |||
REPOST: showing a userform | Excel Programming |