bluegirl
This is the part that shows the userform when a cell in column J is selected
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = Me.Range("J:J").Column Then
UserForm1.Show
End If
End Sub
It goes in the code module behind the sheet, not in a standard module.
Right click on the sheet tab where you want this to happen and choose View
Code. This will take you to the proper code module for this sub.
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"bluegirl " wrote in message
...
I must be just dumb.... I can not seem to grasp how to actually make it
all work.
I have the commands in the VBA sheet, and I have the form set up the
way I want...
How do I make it actually come up when the cell is selected on the
worksheet.
ACK
---
Message posted from http://www.ExcelForum.com/