The help feature in excel is not always helpful enough. I've just been
trying to figure everything out as I go. There are some things I have
to underrstand to proceed with my design.

1. I want to know if I can make a custom right click shortcut menu. Is
there a way to do this with excel? There should be.


2. I made forms with huge fonts and fields. How do I get data that is
input into these fields to also be compiled into a huge list on another
worksheet. On that same note, beings I'm working with multiple fields in
multiple forms and some left blank, I want to be sure that the data from
each field that corresponds with each particular job or customer doesn't
get mixed up or overlapped with other data because of the blanks. That
is if I use some kind of counter to slip into a formula for transfering
the data into the other worksheet. Which reminds me of the other problem
I encountered. I wanted to use a cell reference variable in a simple
formula. Like c5=a(d5) So if d5=7 then c5 will equal what a7 does.
I'm probably missing a symbol or two in the formula.


3. Can you run a macro from an if. The reason i ask is- I'm toggling
text when a button is pushed on a form next to the field. The toggle
button in controls I couldn't figure out a way to do it.


4. In the drawing part of the program. Is there a way to make a shape
within a shape and lock it in to that other shape so when you drag the
big shape around the ones locked in move right along with it.

5. Also if you make a rectangle is there a way to automatically attach
the formulated dimensions onto the rectangle. Also there should be a
way to name the object/shape and have that lock in too. I take it the
macro is the way to accomplish this.

Thanks for answering any of these questions.


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