Dave I will try to clarify better
I get view code from excel
VBA project
open Userform 1
click on toolbox
pull option button from toolbox
go to properties change nbr then to userforn and do same.
I think I did all right havent had time to check yet
Got ambigous name one time tho.
Must of missed changeing something
Thanks Again
Curt


"Dave Peterson" wrote:

There's a difference between creating a "form" on a worksheet and a userform
found inside the VBE--the userform inside the VBE would look a lot like the
dialog that you see when you use Tools|Options.

If they are optionbuttons from the Forms toolbar that are placed on the
worksheet, then you won't see "view code".

I think you'll have to clarify again.



Curt wrote:

These are on user form In the properties page at top it says name is this
what you mean by formula bar. When I view code and click on th option button
am asked to view code or properties. This is where I am ok. From forms
toolbar not active X controls. Useiong option explicd asked to declare
optionbutton1 not defined. Would all need to be defined. also defined as
what. All buttons have one thing to do. Ain't smart enought to do more than
one thing at a time.
Do know this many of those who volunteer for the Vet's Day parade are
looking forward for this program.
I can not express enough my gratuide to those of you who answer this forum.
Will expermint with names and see what happens.
Thank You

"Dave Peterson" wrote:

Are these on a worksheet or on a userform?

If they're on a worksheet, are they optionbuttons from the control toolbox
toolbar or from the Forms toolbar?

If you wanted a macro to do the renaming, the code would be different.

But since there's only 10 optionbuttons, you can do them manually.

You can select the optionbutton and then just type the new name in the namebox
(to the left of the formulabar).

If the optionbuttons are from the Control Toolbox toolbar, then you'll have to
be in design mode first.

As for naming them, you can choose any name that's valid. But if you're going
to refer to them later on, using something mnemonically significant would be
best.

But if you're using a linked cell to get the status, maybe it's not too
important -- I do like naming shapes based on their position in the worksheet:

OptBtn_A1

(if it's always in A1)

Curt wrote:

Thanks to all for smarting me up. Now I get it. Tried on one procedure and
found var not declared. Would someone advise as to what I should call a
option button. Also due to my learning curve. I have buttons numbered from
1-27. Is it possible to renumber these buttons as total i have maybe 10.
Thanks Again

"Dave Peterson" wrote:

I use it to debug my code. If there's a syntax error (or undeclared variable),
then I'll get errors in the compile.

You can read some notes by Don Baarns at about what compiling means to VBA:
http://archive.baarns.com/excel/develop/vbaperfm.asp

And if you're interested in cleaning your code, try Rob Bovey's code cleaner:
You can find it he
http://www.appspro.com/
or directly
http://www.appspro.com/Utilities/CodeCleaner.htm


Curt wrote:

Have never used compile and haven't read any in my books. Do not understand
what it does. Have put together a program for parade. Don't know if compile
is something I should do to this or not.
any suggestions?
Thanks

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson