BTW, if you want to explore userforms, some reading for you


http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp


--

HTH

RP
(remove nothere from the email address if mailing direct)


"famdamly" wrote in
message ...

Bob you rock:)
You must really know your stuff.
I really appreciate the help. I will delve into the right click menu
stuff later, it's way over my head. Atleast I know it's possible.

The grouping thing, that's great. Maybe if I just read the instructions
I would have gotten that.:)

When you say form, do you mean a userform, or are you referring to
something
designed on a spreadsheet?
The latter. Now I'll have to read up on userform.

I don't know VB at all. As a kid I used basic alot and got pretty
creative with that. I'm just trying to get back into it. I notice some
similarities. What I've been doing is using macros and then I look at
the VB to see what kind of tweaks I can do. This is alot of fun.

I think Kleev deciphered my sentence. Thanks Kleev, I will give that a
try.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=490988