View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Making a form into a file...

Ok... Here we go... In Excel right click on the toolbar at the top of the
page. You will get a list of Items with Check marks beside some of them...
Check "Control Toolbox"
and select OK. You will now have the Control Toolbox Toolbar. One of the
item on that toolbar looks like a Grey Button. Click on it. Your Cursor will
change to a Cross Hair. Now you need to select a spot on a work sheet and
click... Tada... You have now created a Command Button. Right click on the
button and select Properties. Change (Name) to cmdShowForm. Change Caption to
Show Form. Now right click on the button and Select View Code. Paste my code
into the code window.

Should look like this...

Private Sub cmdShowForm_Click()
Form1.Show
End Sub

Select the spread sheet again. On the Control Toolbax there is a button that
looks like a ruler triangle and pencil. Click it to exit the design mode. You
now have a button that will show the form... I hope...

HTH



"HFB" wrote:

Um. I can't even figure out how to attach code to a button in a worksheet.
You DO mean a worksheet?

"Jim Thomlinson" wrote:

Put a command button on a sheet and attach the following code to the button...

form1.show

You can get rid of the for using

unload me

or just hide the form with

form1.hide


HTH

"HFB" wrote:

I'm using visual basic (the one that is part of Excel) to make a form for
people to fill out and print. How do I make it so I can open the form
without having to go ToolsMacrosVisual Basic Editor? (or is this a
function reserved for the complete version of VB?)
thanks