View Single Post
 
Old 01-17-2017, 11:22 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

If you're asking how to show the user form when you click, tab or enter into C16, which is merged up to M16,
try this in the Menu sheet module
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address = "$G$16:$M$16" Then UserForm1.Show
End Sub
If that's not what you're asking... I have no idea
Reply With Quote