Form sample

  • Thread starter Thread starter darius
  • Start date Start date
D

darius

Hello

I'm trying to make a form using the form toolbar. I'm accustomed to GUI
designers like those in VB or Delphi but having a hard time figuring
these form controls. For one thing, I don't quite know how to manipulate
them. I expect to have a select tool, a way to move controls around,
align them, group them, etc. I can't even figure out out how to put
radio buttons inside a group box so they're linked together.

Can someone point me to a sample excel file with form controls so I can
get an idea of how they work and how to use them. The help file isn't
terribly helpful.

thanks

btw, I know there's also something called a userform, but I prefer
something that goes on a regular worksheet so it looks like part of an
excel file, rather than a separate app.
 
Documentation on this has long been removed.

you put your option buttons on the sheet, then rubberband the group box
around them.

The tools you want are on the drawing toolbar. Make it visible.

Regards,
Tom Ogilvy
 
Documentation on this has long been removed.

you put your option buttons on the sheet, then rubberband the group
box around them.

The tools you want are on the drawing toolbar. Make it visible.
Click to expand...

Thank you, Tom.

I take it the form tools have been deprecated? Hmm, can I put activex
controls right on a worksheet (i.e., without creating a userform)?
 
Yes. Show the control toolbox toolbar and you'll see some icons that look
familiar. (But they really are different objects that have different
characterisitics.)

If click on that design mode icon (top left of the controltoolbox toolbar), then
you can right click on one of these controls (already on the worksheet) and
select the properties.

You'll see lots of options (many more than on a control from the Forms toolbar).

And if you want a macro to run based on one of these controls, instead of
rightclicking Assign macro (like on the Forms controls), you can just double
click and see where the code goes. (It's behind the worksheet module.)

If I were doing a basic "form" using a worksheet, I'd try to use the Forms
control (my opinion only). I find them easier to work with.

But the controls on the controltoolbox toolbar offers a lot more options.
 
Back
Top