Help with UserForm

01-17-2017, 11:22 AM

NoSparks

Windows 7 64bit Help with UserForm

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform calls other userform, then populate worksheet	Lehoi	Excel Programming	0	02-03-2016 02:58 PM
Help with VBA userform	benn	PowerPoint	1	03-02-2015 11:32 AM
Keep Userform on Top	didjee	PowerPoint	5	10-20-2014 02:22 PM
VBA Code in a UserForm module to delete a Command Button which opens the userform	Simoninparis	Word VBA	2	09-21-2014 03:50 AM
Is it possible to take an input from a UserForm in one document to a UserForm in a do	BoringDavid	Word VBA	5	05-09-2014 09:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:05 AM.