KIM W;236183 Wrote:
Thanks-- I already did that. I am in 2007.
DO you recommende ActiveX control on the worksheet for the button, or
User
Form Control on the worksheet? I am particularly concerned about the
button
staying with the column as things change in the worksheet.
Userform has already been created and works fiine.



You could use a right click event so when the user right clicks a
certain column the userform will show.
Eaxample

Code:
--------------------
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
if target.column=1 then
cancel=true
userform1.show
end if
End Sub

--------------------

The when you right click anywhere on Column A the userform will show.

If you use a button..
Any button will do, I personally like the Button from the Forms tool
bar.

Lots of worksheets require the top rows to be frozen(so you can always
see the Column Headings), if this is the case, you can place the button
on the frozen rows, then it will always be accessible.


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65801